Updating data with linq
Below is a class model created for the Northwind sample database and which I'll be using in this blog post: When we designed our data model using the LINQ to SQL data designer above we defined five data model classes: Product, Category, Customer, Order and Order Detail.The properties of each class map to the columns of a corresponding table in the database.After clicking the Add button the Context Data file is created.Now we should drag all the tables onto the left-hand side of the designer and save (as shown in the following figure).NET Framework 3.5 release, and which enables you to easily model relational databases using . You can use LINQ expressions to query the database with them, as well as update/insert/delete data.Below are the first three parts of my LINQ to SQL series: In today's blog post I'll cover how we we can use the data model we created earlier, and use it to update, insert, and delete data.For example the Update, Insert and/or Get might be in some sort of repository class.
LINQ is a query tool (Q = Query) - so there is no magic LINQ way to update just the single row, except through the (object-oriented) data-context (in the case of LINQ-to-SQL).
Each instance of a class entity represents a row within the database table.
When we defined our data model, the LINQ to SQL designer also created a custom Data Context class that provides the main conduit by which we'll query our database and apply updates/changes.
Today, in this tutorial, I will try to give some more examples on other types of database operations, that writes/updates the database.
These will cover writing and executing ‘Update’/’Insert’/’Delete’ query in the proper way.