SQL to LINQ
-
Hi, how should I write the following query in LINQ ?
@TableName nvarchar(128)
DECLARE @DB_NAME NVARCHAR(128)
SET @DB_NAME = DB_NAME()SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = @DB_NAME
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = @TableName
ORDER BY ORDINAL_POSITIONRegards
-
Hi, how should I write the following query in LINQ ?
@TableName nvarchar(128)
DECLARE @DB_NAME NVARCHAR(128)
SET @DB_NAME = DB_NAME()SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = @DB_NAME
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = @TableName
ORDER BY ORDINAL_POSITIONRegards
You shouldn't. The information schema tables are not visible in LINQ (they are virtual views created by the server). If you really need to do this through LINQ then use .ExecuteQuery
'Howard
-
You shouldn't. The information schema tables are not visible in LINQ (they are virtual views created by the server). If you really need to do this through LINQ then use .ExecuteQuery
'Howard
-
Hi, how should I write the following query in LINQ ?
@TableName nvarchar(128)
DECLARE @DB_NAME NVARCHAR(128)
SET @DB_NAME = DB_NAME()SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = @DB_NAME
AND TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = @TableName
ORDER BY ORDINAL_POSITIONRegards