I have a search result from the database, int searchTerm = \"xx\" var result = from orderLines in context.OrderLineSearch(searchTerm)
I\'m having some timing problems in a unit test of some of my vb code. I set up a test harness by checking for and then deleting records added to the db in the previous testing session, and then I te
We have a database with some fields that are varchar(max) which could contain lots of text however I have a situation where I only want to select the first for example 300 characters from the field fo
I am running into problem when working with linq-to-sql and trying to resolve conflicts. The problem is that sometimes conflict is not detected. Please look on the below code sample:
hey guys, i have a stored procedure known as sp_sitesearch, which returns the result of the site search, now what i want to do is, i want to call this sp to gridview using LINQ, coz one of my friend s
We\'re using LINQ to SQL and WCF for a new middle tier, and we\'re using Data Transfer Objects for passing over the wire rather than using the actual LINQ classes.I\'m going to be using one or the oth
I want to insert a record and then update the record according to s开发者_如何学Ccope_identity of inserted record.
I have a table with a datetime2 field and I need to get all rows out of it where the date is today. Rather oddly (in my opinion but I\'m sure开发者_如何学C there\'s a valid reason for it) if I do:
I want to change the following sql procedure to LINQ to SQL, anyone can help me please. http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
I just started working with PLINQO to implement the repository layer and the data tier in my n-tier distributed system.