LINQ系列:LINQ to SQL Where条件
来源:互联网 发布:草莓音乐节 上海 知乎 编辑:程序博客网 时间:2024/04/25 21:31
1. 单一条件查询
var expr = context.Products .Where(p => p.ProductName == "LINQ to SQL");
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] WHERE N'LINQ to SQL' = [Extent1].[ProductName]
2. 组合条件查询
var expr = context.Products .Where(p => p.ProductName == "LINQ to SQL" && p.UnitPrice > 10m);
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] WHERE (N'LINQ to SQL' = [Extent1].[ProductName]) AND ([Extent1].[UnitPrice] > cast(10 as decimal(18)))
3. Like查询
var expr = from p in context.Products where p.ProductName.StartsWith("LINQ") select new { p.ProductID, p.ProductName };
SELECT [Extent1].[ProductID] AS [ProductID], [Extent1].[ProductName] AS [ProductName] FROM [dbo].[Product] AS [Extent1] WHERE [Extent1].[ProductName] LIKE N'LINQ%'
var expr = from p in context.Products where p.ProductName.EndsWith("LINQ") select new { p.ProductID, p.ProductName };
SELECT [Extent1].[ProductID] AS [ProductID], [Extent1].[ProductName] AS [ProductName] FROM [dbo].[Product] AS [Extent1] WHERE [Extent1].[ProductName] LIKE N'%LINQ'
var expr = from p in context.Products where p.ProductName.Contains("LINQ") select new { p.ProductID, p.ProductName };
SELECT [Extent1].[ProductID] AS [ProductID], [Extent1].[ProductName] AS [ProductName] FROM [dbo].[Product] AS [Extent1] WHERE [Extent1].[ProductName] LIKE N'%LINQ%'
阅读全文
0 0
- LINQ系列:LINQ to SQL Where条件
- LINQ系列:LINQ to SQL Where条件
- linq to sql where 多条件 or and
- linq to sql where 用法
- linq to sql 用法 ----- where
- LINQ系列:LINQ to SQL Select查询
- LINQ系列:LINQ to SQL Join连接
- LINQ系列:LINQ to SQL Concat/Union
- LINQ系列:LINQ to SQL Take/Skip
- linq 追加Where条件
- LINQ to SQL语句(1)之Where
- LINQ to SQL语句(1)之Where
- LINQ to SQL语句(1)之Where
- LINQ to SQL语句(1)之Where
- Linq to sql :查询句法---where
- LINQ to SQL语句(1)之Where
- LINQ to SQL语句之Where
- LINQ to SQL语句(1)之Where
- 1112: [POI2008]砖块Klo
- 二维数组置换
- LeetCode Weekly Contest 39
- 34.css总结
- POJ 2525 Text Formalization 笔记
- LINQ系列:LINQ to SQL Where条件
- Dockerfile中ONBUILD的用法
- Mipmap
- Wish官方运营手册:开启移动跨境电商之路,Jason Lee力荐!
- 穷举法、贪心法、蚁群算法、遗传算法、模拟退火算法介绍
- 鸟哥Linux学习之——归档与压缩
- Codeforces Round #396 (Div. 2)
- Python笔记
- 正向代理、反向代理总结