LinqEntityDataReader Work Item Rss Feed

CLOSED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Mon, 03 Nov 2008 23:08:21 GMT

COMMENTED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 08 Oct 2008 19:49:28 GMT

If the LINQ entity has a relationship to other table (e.g. a CustomerID field in the Orders table), I get an InvalidOperationException:
"The given ColumnMapping does not match up with any column in the source or destination."

I tracked this down to the EntityDataReader constructor. In the propertyCache query, we just need to add a where clause to filter out the table entity classes (e.g. "Customer") like this:

var cc = from p in t.GetProperties(BindingFlags.Instance | BindingFlags.Public)
where p.PropertyType.Namespace != this.GetType().Namespace // filter out the joined table properties
select p;

Of course, this assumes that the EntityDataReader class is in the same namespace as the LINQ data context class. The filter condition could also be a !StartsWith instead of != to support nested classes/namespaces...
Comments: Uploaded a new version today that should resolve this issue, along with better support for Entity Framework and dramatically improved performance for large collections. For selecting which properties to project, there is now a list of types which get projected into DataReader columns. HashSet<Type> set = new HashSet<Type>() { //reference types typeof(String), typeof(Byte[]), //value types typeof(Byte), typeof(Int16), typeof(Int32), typeof(Int64), typeof(Single), typeof(Double), typeof(Decimal), typeof(DateTime), typeof(Guid), typeof(Boolean), typeof(TimeSpan), //nullable value types typeof(Byte?), typeof(Int16?), typeof(Int32?), typeof(Int64?), typeof(Single?), typeof(Double?), typeof(Decimal?), typeof(DateTime?), typeof(Guid?), typeof(Boolean?), typeof(TimeSpan?) }; In addition for Entity Framework entities, properties of type EntityReference will be traversed to get the key values of the related entity. David

COMMENTED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 08 Oct 2008 19:49:13 GMT

If the LINQ entity has a relationship to other table (e.g. a CustomerID field in the Orders table), I get an InvalidOperationException:
"The given ColumnMapping does not match up with any column in the source or destination."

I tracked this down to the EntityDataReader constructor. In the propertyCache query, we just need to add a where clause to filter out the table entity classes (e.g. "Customer") like this:

var cc = from p in t.GetProperties(BindingFlags.Instance | BindingFlags.Public)
where p.PropertyType.Namespace != this.GetType().Namespace // filter out the joined table properties
select p;

Of course, this assumes that the EntityDataReader class is in the same namespace as the LINQ data context class. The filter condition could also be a !StartsWith instead of != to support nested classes/namespaces...
Comments: Uploaded a new version today that should resolve this issue, along with better support for Entity Framework and dramatically improved performance for large collections. For selecting which properties to project, there is now a list of types which get projected into DataReader columns. {{ HashSet<Type> set = new HashSet<Type>() { //reference types typeof(String), typeof(Byte[]), //value types typeof(Byte), typeof(Int16), typeof(Int32), typeof(Int64), typeof(Single), typeof(Double), typeof(Decimal), typeof(DateTime), typeof(Guid), typeof(Boolean), typeof(TimeSpan), //nullable value types typeof(Byte?), typeof(Int16?), typeof(Int32?), typeof(Int64?), typeof(Single?), typeof(Double?), typeof(Decimal?), typeof(DateTime?), typeof(Guid?), typeof(Boolean?), typeof(TimeSpan?) }; }} In addition for Entity Framework entities, properties of type EntityReference will be traversed to get the key values of the related entity. David

EDITED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 08 Oct 2008 19:48:41 GMT

COMMENTED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 08 Oct 2008 19:48:41 GMT

EDITED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 01 Oct 2008 22:22:18 GMT

COMMENTED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Wed, 01 Oct 2008 22:22:18 GMT

If the LINQ entity has a relationship to other table (e.g. a CustomerID field in the Orders table), I get an InvalidOperationException:
"The given ColumnMapping does not match up with any column in the source or destination."

I tracked this down to the EntityDataReader constructor. In the propertyCache query, we just need to add a where clause to filter out the table entity classes (e.g. "Customer") like this:

var cc = from p in t.GetProperties(BindingFlags.Instance | BindingFlags.Public)
where p.PropertyType.Namespace != this.GetType().Namespace // filter out the joined table properties
select p;

Of course, this assumes that the EntityDataReader class is in the same namespace as the LINQ data context class. The filter condition could also be a !StartsWith instead of != to support nested classes/namespaces...
Comments: Uploaded a new version today that should resolve this issue, along with better support for Entity Framework and dramatically improved performance for large collections. The property filter I ended up with is this: var allProperties = from p in thisType.GetProperties() where p.PropertyType != typeof(EntityKey) //EF infrastructure properties && p.PropertyType != typeof(EntityState) //EF infrastructure properties && !typeof(EntityObject).IsAssignableFrom(p.PropertyType) //EF Objects && !typeof(INotifyPropertyChanged).IsAssignableFrom(p.PropertyType) //L2S objects select new { PropertyInfo=p, IsRelationProperty = typeof(RelatedEnd).IsAssignableFrom(p.PropertyType) };

EDITED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Thu, 25 Sep 2008 00:09:28 GMT

COMMENTED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

dbrowne — Thu, 25 Sep 2008 00:09:27 GMT

CREATED ISSUE: InvalidOperationException when bulk inserting entities with relationships to other tables

ubergeek — Sun, 14 Sep 2008 04:15:48 GMT