今天，我创建了代理实体来从内存中加载查找数据。
我建议，实体框架应该足够聪明，不要生成国家/地区表的连接
DbContext.Users.Include(u => u.Country.Select(c => c.Place))
相反，EF应该从内存中获取数据。
你如何使用实体框架处理查找数据？
所以，您希望EF在访问之前急于将所有查找表加载到内存中吗？这听起来有点凌乱和笨拙。（如果查找有更新怎么办？如何同步？）如果使用Pks，加入查找表会很快。如果需要在内存中加载查找表，仍然需要在linq查询中连接保存表数据的代理对象。我没有确凿的数据，但我看不出这两种技术在性能上有多大差异。如果有的话，Linq的例子可能会慢一些。
我的经验法则是：如果两种技术在速度和回报方面相似，那就选择一种不那么复杂、更容易维护的技术（在你的例子中，使用Include（））。
As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....
I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...
I ve got some code which sets up a datacontext. Often enough, the datacontext should be set to some underlying data collection, such as an ObservableCollection - but occasionally I d like to set it ...
I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...
NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...