search

mrahhal / Migrator.EF6

.NET Core CLI tool to enable EF6 migrations in an Asp.Net Core app.
MIT License
82 stars 15 forks source link

JOIN Tables fails in NetCore 3.0 & EF6.3 with Method syntax (but works with Query...) #70

Closed GuyBenhaim closed 5 years ago

GuyBenhaim commented 5 years ago

Hello, With EDMX migration code I fail in joining two tables: using Method syntax the properties of the 2nd table do not appear and prevent defining the InnerKeySelctor (Only the External Declaration options appear). This causes an error and I cannot compile.

Example: var list = db.PP.Where(pp => pp.F0 == 1).Join(db.OP, pp => pp.F1, op => op. , (pp, op) => new {pp, op}).Select(pp => pp.F3_ID).ToList(); Here for op the properteis do not appear.

Surprisingly, using Query syntax the properties appear and the join is performed ok.

Please advise.

mrahhal commented 5 years ago

Hello,

.Net Core 3.0 isn't supported yet, I have a couple of problems I still have to solve (but currently at a stalemate as I have no clue how to proceed on this). You can follow the progress at https://github.com/mrahhal/Migrator.EF6/issues/67.

GuyBenhaim commented 5 years ago

Hello, I was actaully referring to the example code that Diego from MS has provided to enable supporting EDMX and .NetCore 3

mrahhal commented 5 years ago

In that case, I honestly not sure how Migrator.EF6 fits here. This is just a tool to create migration files and has nothing to do with runtime.

GuyBenhaim commented 5 years ago

ok, thx