Migrations support

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

Id #744 | Release: None | Updated: Wed at 2:58 PM by makalini | Created: Wed at 2:58 PM by makalini

Unable to load db when property has column type constraint set to "datetime2"

There were earlier posts claiming a similar issue was already resolved but the latest version of Effort.EF6 does not unfortunately solve it. When table has one of columns configured as follows: P...

Id #743 | Release: None | Updated: Dec 10 at 12:10 PM by radgroza | Created: Dec 10 at 12:10 PM by radgroza

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 at 12:12 AM by azabluda | Created: Nov 29 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 at 4:31 PM by herrHeinz | Created: Nov 13 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 at 3:36 AM by sclaughl | Created: Nov 6 at 3:36 AM by sclaughl

MissingMethodEception with EF 6.1.2 beta and Effort.EF6 1.1.1

Today I updated to the newwest EF6 beta and now I'm getting the following exception when calling SaveChanges(): System.Data.Entity.Infrastructure.DbUpdateException: System.Data.Entity.Infrastructur...

Id #739 | Release: None | Updated: Dec 4 at 2:09 PM by mjamin | Created: Nov 5 at 2:15 PM by wertzui

An expression of type 'System.Nullable`1[System.Int32]' cannot be used to initialize an array of type 'DataRow5'

I have the following query that works correctly when connecting to SQL server: using (var db = ...the db context) { var tenderInfos = db.Set<ElectronicPaymentTenderInfo>(); ...

Id #738 | Release: None | Updated: Nov 13 at 8:46 PM by tamasflamich | Created: Nov 5 at 10:18 AM by michalwozniak

Log SQL queries

Hi, I try to write the Entity Framework log to the console using: this.Database.Log = s => System.Console.Write(s); However, I got everything but the query: Started transaction at 27-10-14 20:47:...

Id #737 | Release: None | Updated: Dec 11 at 10:56 AM by Jowen | Created: Oct 27 at 8:51 PM by marthijnh

Sybase ASE EDMX bug

I have an entity model of a Sybase ASE database that I am trying to mock and when i try to create a transient of if, I get the following Exception System.Data.MetadataException Additional Inform...

Id #736 | Release: None | Updated: Oct 14 at 7:06 PM by sparticus_37 | Created: Oct 14 at 8:24 AM by tamasflamich

Nested Any

I have a pair of tables, with a 1-many relationship, and a FK defined. The model has navigational properties defined, child.parent and parent.children. What works, against SQL Server, and doesn't...

Id #735 | Release: None | Updated: Nov 13 at 7:05 PM by tamasflamich | Created: Sep 8 at 7:56 PM by tamasflamich