Use of Entity Framework Core not viable while pulling from database
What do you recommend for using ef core, now for saving the process is the same but it is not feasible make the lot of include, theinclude to load an EDI Message, if using LazyLoading the n+1 issue raise.
Comments
5 comments
We have only tested the templates with Entity Framework 6. I can recommend you to refer to MSDN's documentation on how to work with EF Core. The EDI templates are simple C# classes; hence, all Microsoft recommendations will also apply to the EDI templates.
Hi Don. I know EDI Templates are just POCOs, the main issue is that with EF vs EF Core you just need to Load the root entity and the complete EDI Template is populated from Database, in the case of EF Core a lot of Include, ThenInclude need to be writte, maybe a Helper that abstract this work can be include in the Library o Examples.
Regards
Hi,
We are not actively looking into this because it's Entity Framework's thing. EdiFabric's templates CAN be used with Entity Framework 6, but that's about the extent we have the resources to go to. This doesn't mean that we won't consider creating some kind of helper, as you said, at some point in the future.
Hi Don. Here i try to use the template with EF Core. The saving process was a success, but the pulling process doesn't work neither with Eager loading nor Lazy Loading, the only property is loaded is Id property. Do you have any recommendation.
var res = db.TS837P.Include(x => x.ST)
.Include(x => x.BHT_BeginningOfHierarchicalTransaction)
.Include(x => x.AllNM1)
.ThenInclude(x => x.Loop1000A).ThenInclude(x => x.NM1_SubmitterName).FirstOrDefault();
Hi, Omar.. How did you do saving process using EF Core? I'm having issues with it, because the saved data is always NULL.
Please sign in to leave a comment.