I call a stored procedure via Linq-to-SQL. This stored procedure simply processes data that I\'ve already inserted into another table. On large data sets, I get a timeout exception:
Lets say I have 3 tables Posts, PostTags and Tags defining a many-to-many relationship. I want to get a lookup table that will give me all the Posts related to a given tag so I use the following code:
I am new to Linq to SQL, but I am surprised at the problems I am having updating a table. From reading various sources I think the problem I get is a problem with the ORM mapping, but even so, given I
public static void MyFunction(MyErrorClass err) { var query = from filter in DataContext.ErrorFilters select filter;
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would l
I have a basic SQL Table ( pKey INT, TransDate smallDateTime, Amount Float) I simply want to emulate this SQL in LINQ
I have b开发者_运维技巧een using LINQ with compiled queries, basically passing into the compiled query using Func but the problem is that it has a maximum of four parameters.
I seem to be having a problem when using Linq to Sql in which the Where method adds a string reference to the criteria list.When the reference is changed, it produces erroneous results.For example, th
I\'ve done a brief search of this site, and googled this, but can\'t seem to find a good example. I\'m still trying to get my head around the whole \"Lambda Expressions\" thing.
I\'m creating an app that will have a fair amount of users.Everytime someone views a page or performs an activity I will be writing to a log.While I\'m concerned about the performance of that in itsel