Hi I have an MVC app I m calling a stored procedure from. The reason I m using a stored procedure is because the query is quite complex and it already exists so I may as well use it.
It basically returns to me a :
IEnumerable<Activity>
这是好的。
有许多外国关键财产,例如:
AreaId
这里有人居住。
然而,在我的模型中,我有导航财产:
// Navigation properties
public virtual Area Area { get; set; }
当然,哪里有人通过储存程序带住。
我不禁要问,这些导航财产是否很容易有人居住。
我认为,我听到了一些你可以呼吁贵实体更新导航性能的指挥。
你们可以这样做:
context.Entry(loadedEntity).Reference(l => l.Area).Load();
但是,如果你要求每个实体在你的列举中都这样做,则不会有出色的业绩,因为每个<代码>都将单独查询和数据库。 页: 1 这种做法不利于使用储存的程序——一旦你采取这种方式,你就应当有另一个储存程序来装载所有需要的地区。
I have been trying to get the Entity Framework to work in my web application using MySQL. It works fine on my local pc, but doesn t work when I put it on the server. Since the server is a shared ...
I am using the Entity Framework with SQL Server. I have a many to many relationship between 2 tables. I have created a join table with just the primary key fields of the 2 tables. In the designer, the ...
I am in the process of developing a desktop application that needs a database. The application is currently targeted to SQL Express 2005 and works wonderfully. However, I m not crazy about having ...
I am using the ADO entity framework for the first time and am not sure of the best way of inserting db recored that contain foreign keys. this is the code that i am using, I would appreciate any ...
I have a table called ASB and a table called PeopleInvolved. There is a junction table called PeopleInvolved_ASB which simply contains an ASBID and a PeopleInvolvedID column. The columns act as a ...
I m using ASP.NET MVC and Entity Framework. I m going to pass a complex entity to the client side and allow the user to modify it, and post it back to the controller. But I don t know how to do that ...
I run this code: var cos = from k in _db.klienci_do_trasy where k.klient_id == 5 select k; but the query send to database is: SELECT * FROM `klienci_do_trasy` LIMIT 0, 30 why is it for, there ...
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 ...