Its not even throwing any exception also,please some one point me what am missing here. if i pass the value as SESID=4747747 then it update that record. Here what i missed my input value SESID == "4747747" //this have whitespace that's why it didn't updated that particular record.
I am having difficulties UPDATING the databes via LINQ to SQL, inserting a new record works fine.
I have looked through as many of the same type of issues here on SO , such as this one Linq-to-Sql Submit Changes not updating fields … You need to get that record from the database firstly, then update that record and then save it.
Right now you are not getting it out of the database when you create your Database Data Context.
I don't know why it wouldn't be there, but I've had some weirdness using EF with some existing databases that weren't built real well. You're calling Submit Changes on the context, but you're never changing anything in that context.
Your get Recrod method does not use the context you created, and likely uses a different context.
This is strange b/c the DB is properly connected and functioning through the fact that the Data Context inserts a new row with no issues. This is the code, is copied dirrectly from the database and is just there to check against the currently selected rows primary key is the same, so I know I am trying to update the same row. But still no closer to finding out what is going wrong. EDIT: Linq to SQL does not support update like that.
I have looked up the issue almost everyone says that it is in issue with the table nothing a primary key.
However my table has a primary key assigned to it and yet Submit Changes does not happen.
I am having an issue with the Submit Changes function provided by the linq to DB implementation in C#.
When I run the command, nothing throws an error but the record never gets updated.