Entity Framework Stored Procedures Exception

Question

I have the following Entity Framework model:

Entities

It's a very simple model and was working fine when Entity Framework was generating the SQL. When I mapped the entities to stored procedures I get the following error when trying to create a LogEntry:

Unable to determine a valid ordering for dependent operations. Dependencies may exist due to foreign key constraints, model requirements, or store-generated values.

The code I am using to make a LogEntry looks like the following:

le.DateAndTime = DateTime.Now;
le.User = (Guid)Membership.GetUser().ProviderUserKey;

Log log = lr.GetLog(le.LogId);
log.LogEntries.Add(le);

lr.Save(); // lr is an instance of LogsRepository, defined earlier in the class

The exception isn't thrown until lr.Save() is called.

Can anybody help me decipher this? I have stored procedures which all work on their own, independent of entity framework, mapped to the entities.

knpwrs · Accepted Answer · 2011-07-11 19:58:02Z

2

I managed to figure out what was causing the error. Take a look at the following mapping setup:

Log Mapping

As you can see, I had a result column binding from UpdateLog, problem being that UpdateLog doesn't return anything. I accidentally put this into the mapping. After deleting the result column binding everything works again.

answered Jul 11, 2011 at 19:58

knpwrs

16.7k12 gold badges67 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bernhard Hofmann · Accepted Answer · 2011-07-11 19:37:41Z

0

It doesn't look like you're using the stored procedure. If you add a function import for the procedure, you can call the function import directly on the context.

answered Jul 11, 2011 at 19:37

Bernhard Hofmann

10.4k12 gold badges65 silver badges80 bronze badges

1 Comment

knpwrs Over a year ago

I mapped the stored procedures to the entities in the entity designer according to the following screenshots: imgur.com/a/em6YK This has worked fine in the past. I only use function imports for select operations.

Collectives™ on Stack Overflow

Entity Framework Stored Procedures Exception

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related