Scenario: ASP.Net web app (n-tier linq2sql) on local IISwith connection to SQL 2008 database over VPN.Some data is replicated to a local SQL 2008 express DB (different name).If the connection is down
I write this code: Rep_Regions clsr = new Rep_Regions(); Func<Regions, bool> filter = r => r.RegionID == int.Parse(textBox5.Text);
I\'m stumped on this performance issue.When paging a RadGrid I get instantaneous results.However, when I filter any of the columns, the query takes around 10 seconds to complete and any paging applied
I want to use Linq to SQL for db communications. I have read many a page mentioning Linq is slow, but I like its being rapid development technique.
Over the last few months I\'ve been concentrating on the new Entity Framework versions, but from now on I\'v开发者_C百科e to build a complete new .net 3.5 application.
I would like to make a simple operation with LinqToSql but I cannot find the right way. I have the following tables, hereby represented with an EF-generated class diagram:
How to translate query like \"select 1, 2\" (i.e. without FROM clause) to LINQ statement? Thanks! I need to get permissions for a set of user groups. In SQL it looks like
I am in the process of converting our internal web application from Linq-To-Sql to EF CodeFirst from an existing database.I have been getting annoyed with Linq-To-Sql\'s limitations more and more late
I\'m trying to build left outer join queries with Linq Expressions but now I really hit the wall. What I want to accomplish is the following query:
I get this error when w开发者_JAVA技巧riting to the database: A dependent property in a ReferentialConstraint is mapped to a