Issue with provider specific data types

Hi, A property in one of my entities is mapped to XML data type in sql server. I was getting an exception when initializing the context "sequence has no matching......". I looked at the forum and...

Id #750 | Release: None | Updated: Jan 22 at 3:42 PM by harinatha | Created: Jan 22 at 3:42 PM by harinatha

Collections are null if they are empty

Consider this POCO class Family { public int FamilyID {get; set;} public ICollection<Person> Children {get; set;} } This code throws a null reference exception. DbConnection conn = DbConnectionFa...

Id #749 | Release: None | Updated: Jan 7 at 6:19 PM by ykosbie | Created: Jan 7 at 6:19 PM by ykosbie

"Argument types do not match" error with Nullable DateTime ?? Operator

I have a problem when querying a condition using the ?? Operator on a Nullable<DateTime> property of my entity. "result1" and "result2" work fine. "result3" throws an "Argument types do not matc...

Id #748 | Release: None | Updated: Jan 12 at 10:28 PM by tamasflamich | Created: Jan 6 at 10:13 PM by Tpancoast

Unsupported Column Types

I've just inherited a large EF6 DbContext with lots of entities in it. They appear to make frequent use of attributes, like so: [Column(TypeName = "timestamp")] [MaxLength(8)] [Timestamp] public by...

Id #747 | Release: None | Updated: Dec 30, 2014 at 6:15 AM by tbowlesonthehouse | Created: Dec 30, 2014 at 6:12 AM by tbowlesonthehouse

Entity Framework 6.1.2 problem

When I upgrade to Entity Framework 6.1.2, I got the following error: System.MissingMethodException Method not found: 'Void System.Data.Entity.Core.Common.DbCommandDefinition..ctor(System.Data.Co...

Id #746 | Release: None | Updated: Jan 6 at 12:33 PM by Tpancoast | Created: Dec 28, 2014 at 6:39 PM by hikalkan

Lazy Loading disabled but Effort eagerly loads all

We have "LazyLoadingEnabled" set to false for our implementation of DbContext. I've double-checked in a production integration test and related entities are only loaded if we explicitly call an "I...

Id #745 | Release: None | Updated: Dec 26, 2014 at 4:46 PM by Z3Nzero | Created: Dec 22, 2014 at 9:53 PM by Z3Nzero

Migrations support

We define foreign keys and indices with fluent API in migrations. Would be nice to support them.

Id #744 | Release: None | Updated: Dec 17, 2014 at 2:58 PM by makalini | Created: Dec 17, 2014 at 2:58 PM by makalini

string -> decimal conversion in queries

The recently resolved https://effort.codeplex.com/workitem/724 claims to have fixed the problem of 'int -> string' conversions, but similar issues with other CAST operations still seem to be presen...

Id #742 | Release: None | Updated: Nov 29, 2014 at 12:12 AM by azabluda | Created: Nov 29, 2014 at 12:09 AM by azabluda

NMemory regex bug

Upon further investigation, this appears to be a bug with NMemory. NMemory has an explicit implementation of SQL Like using Regex. The following line appears to be the culprit: pattern = pattern.R...

Id #741 | Release: None | Updated: Nov 14, 2014 at 4:31 PM by herrHeinz | Created: Nov 13, 2014 at 9:03 PM by tamasflamich

Same table name in different schemas causes errors

Create two tables with the same name placed in two different schemas. Create two new models, each mapped to one of the tables. Use Effort to read / write the models. Observe you get type / mapp...

Id #740 | Release: None | Updated: Nov 6, 2014 at 3:36 AM by sclaughl | Created: Nov 6, 2014 at 3:36 AM by sclaughl