linq not in
2024-04-02 00:47:20
linq not in 查询 or join not in
var query = from c in _opvRepository.Table
join a in _orderRepository.Table on c.OrderId equals a.Id
join p in _pvRepository.Table on c.ProductVariantId equals p.Id
join e in _productRepository.Table on p.ProductId equals e.Id
where a.CustomerId == customerId & !(from s in _productReviewRepository.Table select s.ProductId).Contains(a.CustomerId & p.ProductId)
select new CustomerChapter()
{
Name = p.Name,
ProdcutName = e.Name,
CreatedOn = a.CreatedOnUtc,
ProductId = p.ProductId,
Id = a.CustomerId,
};生成的sql 语句如下
SELECT
[Filter2].[OrderId] AS [OrderId],
[Filter2].[Name] AS [Name],
[Extent4].[Name] AS [Name1],
[Filter2].[CreatedOnUtc1] AS [CreatedOnUtc],
[Filter2].[ProductId] AS [ProductId],
[Filter2].[CustomerId] AS [CustomerId]
FROM (SELECT [Extent1].[OrderId] AS [OrderId], [Extent2].[CustomerId] AS [CustomerId], [Extent2].[CreatedOnUtc] AS [CreatedOnUtc1], [Extent3].[ProductId] AS [ProductId], [Extent3].[Name] AS [Name]
FROM [dbo].[OrderProductVariant] AS [Extent1]
INNER JOIN [dbo].[Order] AS [Extent2] ON [Extent1].[OrderId] = [Extent2].[Id]
INNER JOIN [dbo].[ProductVariant] AS [Extent3] ON [Extent1].[ProductVariantId] = [Extent3].[Id]
WHERE NOT EXISTS (SELECT
1 AS [C1]
FROM ( SELECT 1 AS X ) AS [SingleRowTable1]
WHERE 1 = 0
) ) AS [Filter2]
INNER JOIN [dbo].[Product] AS [Extent4] ON [Filter2].[ProductId] = [Extent4].[Id]
WHERE [Filter2].[CustomerId] = 1
最新文章
- 在Centos中部署redis运行状态图形化监控工具 — RedisLive
- CF memsql Start[c]UP 2.0 B
- js原生实现淡入淡出
- 如何解决EditText使用时，点击外侧系统键盘不消失的bug
- JWPlayer中字幕文件的配置
- wall 和panel有啥区别
- Android开发之点击两次Back键退出App
- Python 多进程
- 推荐一个CMMI认证查询网站
- 【转】Thunderbird on Ubuntu 12.04 – 调整邮件列表行间距
- Nokia N9开启开发者模式
- select2简单例子
- POJ2796(单调栈)
- Servlet路径映射
- uva 10123 - No Tipping dp 记忆化搜索
- java 继承内存分配
- python爬虫之12306网站--车站信息查询
- char * p = "abc"与const char *p = "abc"
- java web项目为什么我们要放弃jsp？
- LeetCode - Reorganize String