How to use LINQ to SQL query and SQL command
This article mainly explains the "LINQ to SQL query and SQL command how to use", the article explains the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "LINQ to SQL query and SQL command how to use" it!
Execute LINQ to SQL query directly
If the LINQ to SQL query is not sufficient for a specific task, we can use the ExecuteQuery method to execute the LINQ to SQL query and then convert the result of the query directly into an object.
Var products = db.ExecuteQuery ("SELECT [Product List] .Productid," + "[Product List] .ProductName" + "FROM Products AS [Product List]" + "WHERE [Product List] .Discontinued = 0" + "ORDER BY [Product List] .ProductName;")
Statement description: this example uses ExecuteQuery to execute any LINQ to SQL query and maps the resulting rows to a sequence of Product objects.
Execute the SQL command directly
When using DataContext connections, you can use ExecuteCommand to execute SQL commands that do not return objects.
Db.ExecuteCommand ("UPDATE Products SET UnitPriceUnitPrice = UnitPrice + 1.00")
Statement description: use ExecuteCommand to execute arbitrary SQL commands, in this case batch updates that increase the unit price of all products by 1.00.
Thank you for your reading, the above is the content of "how to use LINQ to SQL query and SQL command". After the study of this article, I believe you have a deeper understanding of how to use LINQ to SQL query and SQL command, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!
