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 分类：问答