EF Core 7 tasks

[ErikEJ]

Currently the following features and providers are available:
T4 templates, SQL/Azure SQL, Postgres, SQLite, all with spatial

• Add support for modelling with EF7 using .NET 7
• Add reverse engineering support for EF7
• Add support for dropping T4 templates @bricelam
• Add .dacpac support - 161.x package available @dzsquared
• Add Oracle support @alexkeh
• Add SqlServer NodaTime support @StevenRasmussen
• Add SqlServer HierarchyId support @bricelam - RC2 package available
• Add Sqlite NodaTime support @khellang
• Add Handlebars support @tonysneed
• Add Pomelo support @lauxjpn
• Add Firebird support @cincuranet
• Add SchemaCompare support @JonPSmith https://www.nuget.org/packages/EfCore.SchemaCompare/7.0.0 - awaiting request :-)
• Verify Easy column overrides #1472 with .tt files

[KayakFisher205]

Does this handle the Tables with triggers (ie adds the
entity.ToTable(tb => tb.HasTrigger("merge"));
)?

[ErikEJ]

@KayakFisher205 Yes, it does - have you experienced something else?

[KayakFisher205]

No, I was just checking before I ran the tool. I have like 27 in one Database and I added those by hand. Running to the tool, it looks like it added every trigger on a table. I had just added one line and I guess that took care of all of them. This looks a lot cleaner. Thanks for the update.

[bricelam]

FYI, I started digging into the Handlebars code in bricelam:seven. I intend to finish it and send a PR as time allows. /cc @tonysneed

[ErikEJ]

Any update on EF 7 support @lauxjpn @cincuranet @alexkeh ?

[cincuranet]

High level tracking for Firebird is here.

[alexkeh]

The plan is for an Oracle EF Core 7 provider to be released by the end of this year.

[lauxjpn]

We released 7.0.0-alpha.1 of the Pomelo provider today, that supports all features of EF Core 7. The official GA release will be out by the end of the month.

[ErikEJ]

Thank you all for the updated info! I will add the alpha provider very soon!

[vitalyhermonlabs]

NET7 version isn't creating IndexerProperty for M2M while the previous version was OK

[ErikEJ]

@vitalyhermonlabs How does that relate to this issue? If you see a EF Core bug, please report in the EF Core repo, or create a new issue here.

[tonysneed]

@ErikEJ @bricelam I released beta1 of the EF core 7 upgrade to Handlebars templates: https://github.com/TrackableEntities/EntityFrameworkCore.Scaffolding.Handlebars/releases/tag/v7.0.0-beta1

NuGet package here to test: https://www.nuget.org/packages/EntityFrameworkCore.Scaffolding.Handlebars/7.0.0-beta1

[ErikEJ]

@tonysneed Added to latest daily

[dradermaker]

From some testing, I was able to reverse engineer a database with triggers when using an actual connection to the database as source. However, the HasTrigger properties were not generated when using the dacpac as a source. Is this the expected behavior ?

[ErikEJ]

@dradermaker Good point - just not implemented! I have created: #1590

[dradermaker]

Awesome ! Thanks @ErikEJ ! You have developed a wonderful tool for the community !

[ErikEJ]

Thanks for the kind words, @dradermaker -
I would be very grateful for a rating or review on Visual Studio Marketplace