I’m working with LINQ for the past few weeks. It is a very beautiful technology but with very limited documentation. Today I tried updating database tables with the data captured in a web form.

The code we initially used to update the database tables with the help of LINQ to SQL  is as follows

<span style="color: green">//Initiate LINQ objects<br /> </span>pobjConsultant = <span style="color: blue">new </span><span style="color: #2b91af">t_consultant</span>();<br /> pobjAddress = <span style="color: blue">new </span><span style="color: #2b91af">t_address</span>();<br /> pobjContactDetails = <span style="color: blue">new </span><span style="color: #2b91af">t_contact</span>();<br /> pobjBankRecord = <span style="color: blue">new </span><span style="color: #2b91af">t_bank_record</span>();<br /> <span style="color: green">//<br /> //Gather data from form fields and assign values to the objects<br /> //&#8230;.<br /> //&#8230;.code for assigning values&#8230;<br /> //&#8230;.</span>

<span style="color: blue">using </span>(<span style="color: #2b91af">XITTimesheetDataContext </span>db = <span style="color: blue">new </span><span style="color: #2b91af">XITTimesheetDataContext</span>())<br /> {<br /> <span style="color: green">//<br /> </span>db.t_consultants.Attach(pobjConsultant);<br /> <span style="color: green">// our design does not have a FK between Consultant and address<br /> // as address table is used hold data from many other tables<br /> // like Consultant.<br /> </span>db.t_addresses.Attach(pobjAddress);<br /> db.t_bank_records.Attach(pobjBankRecord);<br /> db.t_contacts.Attach(pobjContactDetails);<br /> db.SubmitChanges();<br /> }

The above code executes without any error but it does not update values in the database tables. After execution of the code none of the new values are updated to the database tables.

Googling through forums revealed that we need to change the code as the following

<span style="color: green">//Initiate LINQ objects<br /> </span>pobjConsultant = <span style="color: blue">new </span><span style="color: #2b91af">t_consultant</span>();<br /> pobjAddress = <span style="color: blue">new </span><span style="color: #2b91af">t_address</span>();<br /> pobjContactDetails = <span style="color: blue">new </span><span style="color: #2b91af">t_contact</span>();<br /> pobjBankRecord = <span style="color: blue">new </span><span style="color: #2b91af">t_bank_record</span>();<br /> <span style="color: green">//<br /> //Gather data from form fields and assign values to the objects<br /> //&#8230;.<br /> //&#8230;.code for assigning values&#8230;<br /> //&#8230;.<br /> </span><span style="color: blue">using </span>(<span style="color: #2b91af">XITTimesheetDataContext </span>db = <span style="color: blue">new </span><span style="color: #2b91af">XITTimesheetDataContext</span>())<br /> {<br /> <span style="color: green">//<br /> </span>db.t_consultants.Attach(pobjConsultant);<br /> db.Refresh(System.Data.Linq.<span style="color: #2b91af">RefreshMode</span>.KeepCurrentValues, pobjConsultant);<br /> <span style="color: green">// our design does not have a FK between Consultant and address<br /> // as address table is used hold data from many other tables<br /> // like Consultant.<br /> </span>db.t_addresses.Attach(pobjAddress);<br /> db.Refresh(System.Data.Linq.<span style="color: #2b91af">RefreshMode</span>.KeepCurrentValues, pobjAddress);<br /> <span style="color: green">//<br /> </span>db.t_bank_records.Attach(pobjBankRecord);<br /> db.Refresh(System.Data.Linq.<span style="color: #2b91af">RefreshMode</span>.KeepCurrentValues, pobjBankRecord);<br /> <span style="color: green">//<br /> </span>db.t_contacts.Attach(pobjContactDetails);<br /> db.Refresh(System.Data.Linq.<span style="color: #2b91af">RefreshMode</span>.KeepCurrentValues, pobjContactDetails);<br /> <span style="color: green">//<br /> </span>db.SubmitChanges();<br /> }

After adding db.Refresh() method calls before submitting the changes solved the problem and the values are updated in the database tables properly.

Not sure about the drawbacks and implication of calling Refresh() method with KeepCurrentValues parameter. But solved my problem of the day. If you are aware of any implications please let me know.

Copyright &copy; 2008 | Tech Dreams. If you are on a mobile phone, please check the new mobile edition at m.techdreams.org

How TO Update Data Using LINQ To SQL [ C#, ASP.NET Programming]

  read more »