Linq2SQL using Update StoredProcedure

Posted by PeterTheNiceGuy on Stack Overflow See other posts from Stack Overflow or by PeterTheNiceGuy
Published on 2010-03-01T16:57:01Z Indexed on 2010/03/16 12:36 UTC
Read the original article Hit count: 465

Filed under:

linq2sql

|

stored-procedures

We use queries generated by Linq for data retrieval but for INSERT and UPDATE we do not allow generated SQL, but restrict to the use of stored procedures.

I connected the Update and the Insert behaviour in the DBML to the stored procedures. The procedures are called, the data gets inserted/updated = all if fine, except in the case of optimistic concurrency.

If a record was changed between retrieval and update, the update should fail.

When Linq generates the Update statement itself, it throws a ChangeConflictException as expected, but using the stored procedure no Exception is thrown.

Thanks a lot for any help on this!

© Stack Overflow or respective owner

Related posts about linq2sql

Linq2SQL using Update StoredProcedure

as seen on Stack Overflow - Search for 'Stack Overflow'
We use queries generated by Linq for data retrieval but for INSERT and UPDATE we do not allow generated SQL, but restrict to the use of stored procedures. I connected the Update and the Insert behaviour in the DBML to the stored procedures. The procedures are called, the data gets inserted/updated… >>> More
How do you use Linq2Sql in your applications ?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm recently migrating to Linq2Sql and all my future projects would be done in Linq2Sql. Having said that, I researched a lot on how to properly plug-in Linq2Sql in application design. what to put at what layer ? Should I use DTOs over Linq2Sql entities ? I did not find any rock-solid material that… >>> More
Linq2Sql relationships and WCF serialization problem

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, here is my scenario i got Table1 id name Table2 id family fid with one to many relationship set between Table1. id and Table2.fid now here is my WCF service Code [OperationContract] public List<Table1> GetCustomers(string numberToFetch) { using (DataClassesDataContext… >>> More
retrieve newly inserted record ID with Linq2SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, i am using the following private BlogDataContext db = new BlogDataContext (); article.Created = DateTime.UtcNow; article.Modified = DateTime.UtcNow; db.Articles.InsertOnSubmit(article); db.SubmitChanges( ); int id = article.Id; i am wondering is this save, i mean will it give me the… >>> More
Validate Linq2Sql before SubmitChanges()

as seen on Stack Overflow - Search for 'Stack Overflow'
Can anyone tell me if/how you can validate the changes in a data context in Linq2Sql before calling SubmitChanges(). The situation I have is that I create a context, perform multiple operations and add many inserts alongside other processing tasks and then rollback if the submit fails. What I'd… >>> More

Related posts about stored-procedures

SubSonic 2.2 missing stored procedures in StoredProcedures.cs when generated with sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We are trying to move from SubSonic 2.0.3 to 2.2 (not using .NET 3.5). When we regenerate the project using SubCommander\sonic.exe and try to compile we get some errors reporting missing members (which should have been automatically generated based on the stored procedures we have). On closer inspection… >>> More
SubSonic missing stored procedures in StoredProcedures.cs when generated with SubCommander sonic.exe

as seen on Stack Overflow - Search for 'Stack Overflow'
We have been using SubSonic to generate our DAL with a lot of success on VS2005 and SubSonic Tools 2.0.3. SubSonic Tools do not work on VS2008 (as far as we can work out) so we have tried to use SubCommander\sonic.exe and are now hitting some problems. When we regenerate the project using SubCommander\sonic… >>> More
Drop all stored procedures in MySQL or using temporary stored procedures

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a statement that can drop all stored procedures in MySQL? Alternatively (if the first one is not possible), is there such thing as temporary stored procedures in MySQL? Something similar to temporary tables? So far, for both tasks, I seem not to find any answers although there were people… >>> More
What is your best-practice advice on implementing SQL stored procedures (in a C# winforms applicatio

as seen on Stack Overflow - Search for 'Stack Overflow'
I have read these very good questions on SO about SQL stored procedures: When should you use stored procedures? and Are Stored Procedures more efficient, in general, than inline statements on modern RDBMS’s? I am a beginner on integrating .NET/SQL though I have used basic SQL functionality for… >>> More
Creating Stored Procedures in MySQL Using HeidiSQL 4&#146;s Stored Routine Editor

as seen on Internet.com - Search for 'Internet.com'
In the "Write MySQL Queries Using HeidiSQL 4" article, we learned how to connect to a MySQL database and execute queries against it using the free HeidiSQL GUI client. Today, we'll learn how to create a stored procedure using HeidiSQL's Stored Procedure Editor. >>> More