'Subquery returned more than 1 value' problem in EntityFramework

Posted by plotnick on Stack Overflow See other posts from Stack Overflow or by plotnick
Published on 2010-05-13T19:24:11Z Indexed on 2010/05/13 20:24 UTC
Read the original article Hit count: 162

Filed under:

entity-framework

I have one 'Transaction' entity object with 'Operations' navproperty with multiplicity of 'Many'.

When I'm adding only one operation per transaction nothing happens, but when I'm trying to add more than one operation, db.SaveChanges() throws an exception like 'Subquery returned more than 1 value blah, blah, blah'

How can I solve that? Help me guys please...

BTW... Could you tell me how can I see the exact query string that EF passes to Sql Server on db.SaveChanges() method?

Related posts about entity-framework

Differences Between NHibernate and Entity Framework

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Introduction NHibernate and Entity Framework are two of the most popular O/RM frameworks on the .NET world. Although they share some functionality, there are some aspects on which they are quite different. This post will describe this differences and will hopefully help you get started with the one… >>> More
Entity Framework & Binding syncronisation

as seen on Stack Overflow - Search for 'Stack Overflow'
* EDIT * Sorry, I should make it clearer. Imagine I have an entity: public class MyObject { public string Name { get; set; } } And I have a ListBox: <ListBox x:Name="lbParts"> <ListBox.ItemTemplate> <DataTemplate> <TextBlock Text="{Binding Name}"/> … >>> More
Joins and UI Binding with the Entity Framework

as seen on Internet.com - Search for 'Internet.com'
Learn how to build queries with the Entity Framework that involve multiple tables as well as binding in the UI with the EntityDataSource. >>> More
Frederick .NET User Group April 2010 Meeting

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
FredNUG is pleased to announce that we have an excellent speaker lined up for April. On April 20th, we’ll start with pizza and social networking at 6:30 PM. Then, starting at 7 PM, Dane Morgridge will present “Getting Started with Entity Framework 4” The scheduled agenda is: 6:30 PM - 7:00… >>> More
[News] NHibernate vs MS Entity Framework

as seen on Dot Net Guru - Search for 'Dot Net Guru'
Voil? une question qui se posera de plus en plus avec la sortie prochaine de .NET V4 et Entity Framework V4, l'outil de mapping objet/relationnel de Microsoft. M?me s'il est vrai que l'opinion de Ayende peut para?tre biais?e du fait qu'il est contributeur NHibernate, son point de vue et surtout ses… >>> More

Developer IT

'Subquery returned more than 1 value' problem in EntityFramework - Developer IT

'Subquery returned more than 1 value' problem in EntityFramework

entity-framework

Related posts about entity-framework

Differences Between NHibernate and Entity Framework

Entity Framework & Binding syncronisation

Joins and UI Binding with the Entity Framework

Frederick .NET User Group April 2010 Meeting

[News] NHibernate vs MS Entity Framework

Categories cloud