Recently, I have discussed about getting started linq to sql in c. That articles also covered for creating select query for retrieving both single and multiple results. Please use the database structure given below, if you want to try the following examples directly. We just need to create a new object of corresponding database table type, then add it to the DataContext object and then commit the changes.
For your information, the above code example is for. NET 3. Just like insert operation, this delete operation example given above will work for. NET framework 3. To edit data, simply first, we will have to retrieve the objects rows and make changes to them wherever needed. Tagged as C. Stats Pranay Rana Rate me:. Please Sign up or sign in to vote. Question Can I update my employee record as given in the function below or do I have to make a query of the employee collection first and then update the data?
Copy Code. Thank you for the feedback. The comment is now awaiting moderation. You will be notified via email when the author replies to your comment. Please select a comment to reply. You can add your comment about this article using the form below. Make sure you provide a valid email address else you won't be notified when the author replies to your comment Please note that all comments are moderated and will be deleted if they are Not relavant to the article Spam Advertising campaigns or links to other sites Abusive content.
Please do not post code, scripts or snippets. Required Invalid Email Address. Security code:. Required Invalid security code. I declare, I accept the site's Privacy Policy. Add Comment. Disclaimer : The code samples and API available at www. You are free to use it for commercial as well as non-commercial use at your own risk, but you cannot use it for posting on blogs or other tutorial websites similar to www. All the code samples and API provided by the authors are solely their creation and neither the author nor the site are responsible if it does not work as intended.
I agree to the above terms. Download Required. What our readers say. Error Details. This site makes use of Cookies. To update data, you need to fetch it out, update the record, and submit the changes:. In the ExecuteCommand statement, you can send the query directly, with the value for the specific record you want to update. Stack Overflow for Teams — Collaborate and share knowledge with a private group.
Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 12 years, 7 months ago. Active 4 years, 8 months ago. Viewed k times. Improve this question. Germstorm 9, 14 14 gold badges 63 63 silver badges 83 83 bronze badges.
Add a comment.
0コメント