Creating new Entities from Stored Procedure

Posted by SK on Stack Overflow See other posts from Stack Overflow or by SK
Published on 2010-03-12T03:19:48Z Indexed on 2010/03/12 3:27 UTC
Read the original article Hit count: 125

Filed under:

entity

|

framework

I have a stored procedure that retrieves existing rows from a table and also creates includes new rows that match the table definition and mapped entity (.net 3.5 entity framework). These new rows are not written to the database in the stored procedure.

The stored procedure executes, but the new rows that were created will not load the navigation properties sucessfully i.e. the rows that do not actually exist in the database.

e.g.

database rows:

key, data, FK

1, xxx, a

2, xxx, b

returned rows from stored procedure:

key, data, FK

1, xxx, a

2, xxx, b

3, yyy, a

4, yyy, b

The entity will load FK entities a and b for rows 1 and 2, but for rows 3 and 4 the FK entity is null.

Do I somehow need to add the new rows to the data context? or turn off tracking?

© Stack Overflow or respective owner

Related posts about entity

Entity Framework + AutoMapper ( Entity to DTO and DTO to Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. i got some problems using EF with AutoMapper. =/ for example : i got 2 related entities ( Customers and Orders ) and theyr DTO classes : class CustomerDTO { public string CustomerID {get;set;} public string CustomerName {get;set;} public IList< OrderDTO Orders {get;set;} } class… >>> More
What .Net Namespace contains Entity for use in a generic repository?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a question that I'm ashamed to ask, but I'm going to have a go at it anyway. I am creating a generic repository in asp.net mvc. I came across an example on this website which I find to be exactly what I was looking for, but there is one problem. It references an object - Entity - and I don't… >>> More
Entity Framework version 1- Brief Synopsis and Tips – Part 1

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
To Do Eager loading use Projections (for e.g. from c in context.Contacts select c, c.Addresses) or use Include Query Builder Methods (Include(“Addresses”)) If there is multi-level hierarchical Data then to eager load all the relationships use Include Query Builder methods like customers.Include("Order… >>> More
Hibernate unknown entity (not missing @Entity or import javax.persistence.Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a really simple class... import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = "users") public class User { … >>> More
Prevent Custom Entity being deleted from Entity Framework during Update Model Wizard

as seen on Stack Overflow - Search for 'Stack Overflow'
In Entity Framework v1 If you create a Custom Entity to map it to a Stored Procedure during FunctionImport and then Select "Update Model from Database" the Update Model Wizard removes the Custom Entity (as added Manually in the SSDL XML prior to functionImport) from the SSDL. Does anyone know if… >>> More

Related posts about framework

Baboon Framework : A revolutionary WPF framework that will save you time and effort

as seen on Code Project - Search for 'Code Project'
This is true code, what you say >>> More
Web-Application Framework - Catharsis - part VI - Framework Architecture

as seen on Code Project - Search for 'Code Project'
Catharsis web-app framework - Framework Architecture >>> More
sync Framework for Compact Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone got sync framework to work on a mobile device as a sync mechanism in place of RDA or Merge replication? If yes, could you point me to any resources available. If one was to start a green field compact framework based application, what would one use as the sync mechanism (sync framework/RDA/Merge… >>> More
Binding not writing to datasource on .NET Compact Framework Form -- works on Full Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem with a bound user control writing back to it's datasource on a NetCF forms application. The application is too complex to post code, so I made a toy version to show you. I create a form, usercontrol with a combobox, a class (testBind) and another class (TestLookup). I bind a property… >>> More
Unity framework - creating & disposing Entity Framework datacontexts at the appropriate time

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, With some kindly help from StackOverflow, I've got Unity Framework to create my chained dependencies, including an Entity Framework datacontext object: using (IUnityContainer container = new UnityContainer()) { container.RegisterType<IMeterView, Meter>(); container.RegisterType<IUnitOfWork… >>> More