Linq to sql updating
Keep Changes, cust Array, cust Array, cust Array); Console. LINQ to SQL is a great tool, but when you’re using it in an n-tier scenario, there are several problems that you have to solve. Anant HI again, Select db1table1.field1,db2table2.field3 from db1table1 inner join db2table2 on db2table2.field5 COLLATE SQL_Latin1_General_CP1_CI_AS = db1table1.field4 Try this. Anant Hi Ananth, This is the query that I am using. Can you make out any difference in the query that you had sent me and the query that is here. Events is in collation Compatibility_52_409_30003 Pewcentral..staff is in collation SQL_Latin1_General_CP1_CI_AS So, I need to get the count of records and here is the query that I am using. But U r saying E is with collation "Compatibility_52_409_30003".
Let's create a simple example which is very simple and also show basic step to use LINQ-To-SQL.
Ur Query says to use "SQL_Latin1_General_CP1_CI_AS" with E. If still facing problems, I think u can change the fashion of query using WHERE IN etc.... Join these table through Enterprice Managers Graphical Query designer and see the generated query in SQL pane.
EDITEDBY collate Compatibility_52_409_30003 I am not sure about where u got coolation "Compatibility_52_409_30003" I can't find this collation in SQL Server. I think u should create a dummy table in same database.
It's just as easy to write bad database access code with LINQ to SQL that doesn't perform well.
In this article, I'll offer five tips to help you avoid accidentally asking LINQ to SQL to shoot you in the foot.