Entity Framework in not in

w23647460 2013-01-09 09:24:23
.Get().Where(p => new int[] { 74169, 74170, 74171 }.Contains(p.nID)).ToList();

这样是有效的,但是换成

int[] ids = new int[]{ 74169, 74170, 74171 };
.Get().Where(p => new int[] { 74169, 74170, 74171 }.Contains(p.nID)).ToList();

这样就没有效果了



求教~
...全文
179 3 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
w23647460 2013-01-10
  • 打赏
  • 举报
回复
sorry 自己写错代码了 方法2 是对的 有效
w23647460 2013-01-10
  • 打赏
  • 举报
回复
1、 .Get().Where(p => new int[] { 74169, 74170, 74171 }.Contains(p.nID)).ToList(); 这样是有效的,但是换成 2、 int[] ids = new int[]{ 74169, 74170, 74171 }; .Get().Where(p => ids.Contains(p.nID)).ToList(); 不好意思发急了,没检查 1 转换执行SQL时是 nID in (74169, 74170, 74171 ) 2 转换执行SQL时是 nID in (74169, 74169, 74169 ) 问题 因为这个数组不是固定的 但是用方法2 又不能包含所以的ID
threenewbee 2013-01-09
  • 打赏
  • 举报
回复
上下有什么区别?
Paperback: 1625 pages Publisher: Apress; 7th ed. 2015 edition (January 1, 2016) Language: English ISBN-10: 1484213335 ISBN-13: 978-1484213339 This new 7th edition of Pro C# 6.0 and the .NET 4.6 Platform has been completely revised and rewritten to reflect the latest changes to the C# language specification and new advances in the .NET Framework. You'll find new chapters covering all the important new features that make .NET 4.6 the most comprehensive release yet, including: A Refined ADO.NET Entity Framework Programming Model Numerous IDE and MVVM Enhancements for WPF Desktop Development Numerous updates to the ASP.NET Web APIs This comes on top of award winning coverage of core C# features, both old and new, that have made the previous editions of this book so popular. Readers will gain a solid foundation of object-oriented development techniques, attributes and reflection, generics and collections as well as numerous advanced topics not found in other texts (such as CIL opcodes and emitting dynamic assemblies). The mission of this book is to provide you with a comprehensive foundation in the C# programming language and the core aspects of the .NET platform plus overviews of technologies built on top of C# and .NET (ADO.NET and Entity Framework, Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), ASP.NET (WebForms, MVC, WebAPI).). Once you digest the information presented in these chapters, you’ll be in a perfect position to apply this knowledge to your specific programming assignments, and you’ll be well equipped to explore the .NET universe on your own terms. What you’ll learn Be the first to understand the .NET 4.6 platform and C# 6. Discover the ins and outs of the leading .NET technology. Learn from an award-winning author who has been teaching the .NET world since version 1.0. Find complete coverage of XAML, .NET 4.6 and Visual Studio 2015 together with discussion of the new Windows Runtime. Who this book is for This book is perfect for anyone who is interested in the new .NET Framework 4.6 and the C# language. Whether you are moving to .NET for the first time or are already writing applications using previous .NET versions, this book will provide you with a comprehensive grounding in the new technology and serve as a complete reference throughout your coding career.

111,097

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • AIGC Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧