i am using sql server 2005 and I think Linq generating queries for a different database version. I got the query string that linq was producing and pasted the linq directly in SQL Server Management studio and it failed with many errors. But the query works well if Linq is used. Any ideas what could be going on. If linq needs to know what database version to use how do I do that?
我正在使用sql server 2005,我认为Linq为不同的数据库版本生成查询。我得到了linq正在生成的查询字符串,并直接在SQL Server Management studio中粘贴了linq,但它失败了许多错误。但是如果使用Linq,查询效果很好。任何想法可能会发生什么。如果linq需要知道使用什么数据库版本我该怎么做?
1 个解决方案
#1
3
LINQ will create a parameterized query. You won't be able to directly copy the SQL into SSMS without adding definitions (and assigning values to) the parameters.
LINQ将创建一个参数化查询。如果不向参数添加定义(并为其分配值),您将无法直接将SQL复制到SSMS中。
#1
3
LINQ will create a parameterized query. You won't be able to directly copy the SQL into SSMS without adding definitions (and assigning values to) the parameters.
LINQ将创建一个参数化查询。如果不向参数添加定义(并为其分配值),您将无法直接将SQL复制到SSMS中。