The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
601 views

Should I refresh query plan cache

Please let me explain my problem and situation: I have a web application - MVC3, MSSQL Server 2005, LinqToSQL. It has been running great until one fine morning I pushed a lot of rows to a table that ...
0
votes
0answers
32 views

What Has To Be Considered In Order To Keep A Database Consistent?

I have developed a Winforms application which handles database requests, with the database lying on a local network server. Therefor I used LINQ to SQL. Now I read about how to use LINQ's support for ...
10
votes
2answers
126 views

A question on SARGability

I just need to confirm that I understand something correctly: I recently viewed an SO question in which a user posted an answer in Linq like: from p in db.table where p.column.AddMinutes(1) > ...
3
votes
1answer
378 views

Why does DataContext.SubmitChanges() Exist?

I'm not sure if this goes here or on Stack Overflow, but I figure someone here might know it. Why did the developers of LINQ decide that not only do you need ctx.InsertOnSubmit(item); but you also ...