linq-to-sql
How can I separate the condition within a LINQ to SQL query?
I am using ASP.NET with C# and I need to make the condition of the query dynamic, Example: Database: NameSex[详细]
2023-04-13 09:54 分类:问答LINQ issue while updating sql server from 2005 to 2008
We are planning to update our production server to 2008 now, but before that we tried to test it on our development server and I am facing some problem in order to connect our websites to it. I was un[详细]
2023-04-13 08:45 分类:问答How to get the amount of colums from a SQL database with LinqDataSource?
I want to make a foreach loop which runs for each column I have in my current table. My situation is that I have my ASP.Net project where I have one Microsoft SQL Model which I imported and created a[详细]
2023-04-13 05:34 分类:问答LINQ query where boolean value is true or false
How can I compare a boolean value to both true and false in a LINQ query? If hideCompleted is true, I want to show values where IsC开发者_如何学Goompleted is false[详细]
2023-04-13 04:47 分类:问答Find hole in sequence using Linq to Sql
I am using Linq to Sql against a SQL Server Compact database. I need a fast way to find the first hole in an integer based column or if none exist the highest number + 1.[详细]
2023-04-13 03:45 分类:问答Error: ASP.NET: 'DataContext accessed after Dispose.'
There are two tables: Account (id) and BranchId(Id,Name,AccountId) and I have this code in pageload protected void Page_Load(object sender, EventArgs e)[详细]
2023-04-13 02:54 分类:问答setting datacontext through Xml instead of DBML file..?
How to set datacontext class through just - XML file not as DBML file .?? Scenario: Has a DBML file with DataContext defined in it.By Specifying the Connection string am accessing one table[详细]
2023-04-12 19:30 分类:问答LINQ to SQL is not updating child element
I\'m grabbing a Cart object, which has a collection of CartItem objects. I have a function to add a CartItem object to the Cart object. If I simply call myCart.CartItems.Add(cartItem), it works fine.[详细]
2023-04-12 17:18 分类:问答LINQ-to-SQL - Group By
I have the following LINQ-to-SQL code var customerList = from cm in dc.ConsignmentMarginBreakdowns join tm in dc.ConsignmentTripBreakdowns on new { Depot = cm.Depot, TripNumber = cm.TripNumber, TripD[详细]
2023-04-12 15:22 分类:问答LINQ and Entity Framework, get sum of related rows of a non mapped column
I want to get the sum of applicants that applied to a specific position, this should not be saved as a column.[详细]
2023-04-12 13:06 分类:问答