This article is organized from the msdn
I. Concepts of LINQ:LINQ is short for Language Integrated Query (Language integration query), which is integrated in. netProgramming LanguageThis allows the query expression to get a good syntax check during compilation, rich metadata, and advantages of smart sensing for other strong languages. net Framework Version 3.5 i
method for creating a specific type of Expression directory tree node, for example, ParameterExpression (indicating a named parameter Expression) or MethodCallExpression (indicating a method call ). The root of the Expression directory tree generated by the compiler is always in the node of Type Expression
The following examples describe how to use the expression directory tree to create a dynamic LINQ query
Part of this article is organized from MSDN
First, the Concept of LINQ:
LINQ is the abbreviation for Language Integrated query (language integration queries), which is integrated in the. NET programming language, which makes query expressions good at compile-time syntax checking, rich metadata, IntelliSense, and othe
Tags: style blog color ar for strong SP div on1. Query all fieldsusing New Northwindcontext ()) { var expr = context. Products; foreach (var in expr) { Console.WriteLine (item. ProductName);} }SELECT [Extent1].[ProductID] as [ProductID], [Extent1].[CategoryID] as [CategoryID], [Extent1].[ProductName] as [ProductName], [Extent1].[UnitPrice] as [UnitPrice], [Extent1].[discontinued] as [discontinued] from
Label: = new Northwindcontext ())
{
var= context. Products;
foreach (var in expr)
{
Console.WriteLine (item. ProductName);
}
} SELECT
[Extent1].[ProductID] as [ProductID],
[Extent1].[CategoryID] as [CategoryID],
[Extent1].[ProductName] as [ProductName],
[Extent1].[UnitPrice] as [UnitPrice],
[Extent1].[discontinued] as [discontinued]
from [dbo].[Product] as [Extent1] 2. Querying a specified field var = context. Products
. Select =
Directory
[10 days to learn about Linq to SQL] day 1-Basic Knowledge
[10 days to learn about Linq to SQL] The next day -- data context
[10 days to learn about Linq to SQL] The third day -- Data
Label:Recently doing projects using LINQ in conjunction with EntityFramework to handle database operations. Want to also use for almost a year, found that some use of skills is necessary to pay attention to, special to do under the summary, I hope that the new friends are helpful. At the beginning of the use of the total loop query subquery, the results of poor performance is not good, now look at all feel
3 courses. SelectAVG (degree) fromScorewhereCNO like'3%'GROUP BY Cno have Count (*) >=5Linq: fromSinchScoreswhereS.cno. StartsWith ("3") group S by s.cno into CCwhereCc. Count () >=5
SelectCc. Average (c =C.degree) Lambda:Scores.Where (S= = S.cno. StartsWith ("3") )
. GroupBy (S=s.cno). Where (CC= = (CC. Count () >=5) )
. Select (CC= CC. Average (c =C.degree)) Linq:sqlmethod like can also write: S.cno. StartsWith ("3") or Sqlmethods.like (S.cno,"%3") 14. Mult
") View Code 12. Grouping example Code queries the average score of at least 5 students in the score table and 3 courses. SelectAVG (degree) fromScorewhereCNO like'3%'GROUP BY Cno have Count (*) >=5Linq: fromSinchScoreswhereS.cno. StartsWith ("3") group S by s.cno into CCwhereCc. Count () >=5
SelectCc. Average (c =C.degree) Lambda:Scores.Where (S= = S.cno. StartsWith ("3") )
. GroupBy (S=s.cno). Where (CC= = (CC. Count () >=5) )
. Select (CC= CC. Average (c =C
may also think about this. Add a filter condition "Nothing more" to add a parameter to the interface, a parameter to the stored procedure, and a condition to the WHERE clause ,...... Working hard.
The customer's filtering condition is as follows: since the order contains the "country" field, you want to filter the condition according to the country, and you can select multiple countries, for example:
The engineer may fall down when he sees the figure ......
The above can be used as a j
This document uses the customers and orders tables in the northwind database as examples to illustrate how to query and add a table in the LINQ to SQL statement.
First, create datacontext and the corresponding entity class through the LINQ to SQL file wizard. If you do not k
filter condition "Nothing more" to add a parameter to the interface, a parameter to the stored procedure, and a condition to the WHERE clause ,...... Working hard.
The customer's filtering condition is as follows: since the order contains the "country" field, you want to filter the condition according to the country, and you can select multiple countries, for example:
The engineer may fall down when he sees the figure ......
The above can be used as a joke, but in other words, there is no uni
LINQ to SQL can query SQL-based data quickly, including the basic object/relation mapper directly in VS, and the O/R mapper can quickly map SQL-based data sources to CLR objects and then use LINQ queries. In the project, right-cli
Just a little bit of Linq was attracted by it, and I suddenly came up with the idea of learning and using it in one breath. So I posted a video on the ASP. NET official website. I am not very good at English, but I can understand how to use it. Below I wrote a little bit of fur I learned. It is a learning record.
First, I use Visual Studio 2008 development tools and SQL Server data sources, which are writte
Linq to SQL: Second of integrated database language query
Step 5: Create Your Object Model1. Open the Data Connections Tree View2. Expand the Northwind folder3. Expand the Tables folder4. Double-click solution explorer to open the Northwind. dbml file.5. Drag the MERs table from the table folder to the Linq to
,sc.degree from course as c,score as SC where c.cno = sc.cnolinq: From C in Courses J Oin SC in Scores on c.cno equals SC. CNO Select New { sc. Sno,c.cname,sc. Degree }lambda: courses.join (Scores, C = c.cno, sc = sc. CNO, (c, sc) = = new { SNO = sc. SNO, CNAME = c.cname,
LINQ to SQL null Query
More than once in the Forum, some netizens asked questions about the query of LINQ null. Here we take the Microsoft northwind database as an example to summarize:
For example, how can I implement an SQL sta
")) . GroupBy (s = s.cno) . Where (cc = (cc. Count () >= 5)) . Select (cc = CC. Average (c = c.degree))Linq:sqlmethodIt can also be written like this:17 13. Grouping 1 Check the average score of the course with at least 5 students enrolled in the score table and begin with 3.2 Select AVG (degree) from score where CNO like ' 3% ' GROUP by CNO have Count (*) >=53 Linq:4 from s in Scores5 w
Label:In the data query, often encountered the need to dynamically build query conditions. Using LINQ to implement this requirement may be more cumbersome than stitching up SQL statements in the past. This article describes 3 ways to dynamically build query conditions at run
Original address: Http://msdn.microsoft.com/zh-cn/dd567295.aspxIn the data query, often encountered the need to dynamically build query conditions. Using LINQ to implement this requirement may be more cumbersome than stitching up SQL statements in the past. This article describes 3 ways to dynamically build
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.