Someone here asked: \"Linq-To-Sql enables calling SPs. If this SP executes an update/delete/insert, do I need to SubmitChanges() after it?\"
I\'m having an issue with updating the database.The app shows the updated value, but the database does not.No errors returned.My table has a PK.Using DotConnect for Oracle, but the LINQ syntax is the
I have created two separate objects, one of class Order and one of class TempOrder. When I tryto insert the TempOrder object in the db using db.Temp开发者_JAVA百科Orders.InsertOnSubmit(obj) and then c
When I run DB.SubmitChanges(); I occasionally get an error that reads: \"Row not found or changed\". The reason why this error bugs me so much is because there will always a row that should be found
One question: Why when I use following code for (int i = 0; i < 10000; i++) { Entity e = new Entity();
I\'ve been doing some searching on the internet, but I can\'t seem to find the awnser. What exceptions can a DataContext throw? Or to be more specific, what exceptions does the DataContext.SubmitChang
Which layer is the best layer to make linq-sql calls as SubmitChanges(), InsertOnSubmit() etc. For example, let\'s say I have two tables Parent and Child. Child table has foreign key on parent (Child
I can\'t figure out the correct way to insert a new record in a child table. There\'s a single datacontext in the app and the target table (CustNotes) is a child of a table named Customer. There\'s a
So at the root of my DB, I have a table \"Customer.\" Customer has foreign keys going to about 6-7 other tables such as Receipts, Addresses, Documents etc. If I were to delete a customer using SubmitC
I have a mapping table like: Article_to_Categories ArticleID CategoryID How would I insert into this table using开发者_开发技巧 linq2sql?Provided that corresponding rows exist in the Article and Ca