Update Reverse Engineering wiki page

[jespersh]

Looked at https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering as I just noticed the new dialog:

And I got a bit overwhelmed by all the options to be honest.

I think some screenshots of Solution Explorer with all the different options could help people (me) in the wiki.
My solution has a ***.Persistence project with DbContext and a ***.Domain project with entities. So I couldn't figure out this full control thing just by looking at it #197 (comment)

[ErikEJ]

Agree, this is something I need to do!

If you could make a screenshot / text description of your folder layout, I can try to help (and get the first entry in the wiki update drafted at the same time!)

[jespersh]

The references between the projects are like this:

For a bit of context: The application layer is "talking" with the persistence layer through interfaces in the application layer and DI registered in the persistence layer.

What I normally do is just reverse engineering new entities and copying the parts from AldenteDbContext2 (generated in Entities folder) to AldenteDbContext

[ErikEJ]

assuming that you are running EF Core Power Tools in the Aldente.Journal.Domain, the following values should work:

Namespace: Aldente.Journal
Entity path: Entities
Entity Sub-namespace: Domain.Entities
DbContext path : c:\code\xxx\Aldenete.Journal.Persistence
DbContext sub-namepsace: Persistence

(and thanks for dog-fooding!)

[ErikEJ]

@jespersh did you try this out?

[jespersh]

Back in the work seat and tried this out. For the most part it worked as expected.
Then I had this oddity in my Aldente.Journal.Domain.csproj added:

<Project Sdk="Microsoft.NET.Sdk">
...
  <ItemGroup>
    <Compile Include="..\Aldente.Journal.Persistence\AldenteDbContext.cs" Link="AldenteDbContext.cs" />
  </ItemGroup>
...
</Project>

This is the only thing I'd even consider an error.
The few other oddities I met are either because of my namespace (entity and namespace named Journal) or unhandled mysql datatypes (zerofill).

Knowing what I know today, then I'd move the generated AldenteDbContext.cs into: c:\code\xxx\Aldenete.Journal.Persistence\Generated\, because I have some special bits too.

So the screenshots are these:

What I am wondering about is this:

• My non-generated AldenteDbContext would have a dependency injected into its constructor. How do I avoid the constructors in the partial generated by the tool? Or am I using it incorrectly. Should this be done as a property injection instead?

...
    public AldenteDbContext(ISecrets secrets)
    {
        _secrets = secrets;
    }
...

Maybe a followup issue on this would be appropriate

[ErikEJ]

1: What is your target framework in Aldente.Journal.Domain.csproj ?

2: The constructor issue - is that something that just happended now? Otherwise it sounds like a feature request, so feel free to post a new issue.

3: "unhandled mysql datatypes (zerofill)." - is that a MySQL provider issue/bug?

[jespersh]

1. netstandard2.0

2. What I have been doing is using Reverse Engineer like this:

• Reverse engineer the specific table(s) I haven't yet added to get the Entity model(s) and a 2nd DbContext (the DbContext that always ended up in the Domain project) for the specific entity/entities.
• Copy the parts from the DbContext that ends up in the Domain project into the DbContext I actually use in the Persistence project.

That way I always ended up a DbContext I was in control of because I was always cut/pasting the newly reverse engineered parts.
If I needed to only use your partial as is, now that it is able to end up in the right location, then I think I'd need a constructor-less generated partial and without the OnConfiguring method. That way I can create my own partial and not worry about having to re-generate the Reverse Engineered DbContext.
My own partial would contain the OnConfiguring override and appropriate constructors. Do you think that's a reasonable feature request?

3. Yeah. I should look into fixing that for them so I don't hit that issue, because those properties are just silently skipped in the Entity model yikes.

[ErikEJ]

1: Looks like I should only be doing this for .NET Framework projects: https://github.com/ErikEJ/EFCorePowerTools/blob/master/src/GUI/EFCorePowerTools/Handlers/ReverseEngineerHandler.cs#L247

2: That is not how you are supposed to use it !! 😄
So:
a: Why do you need a constructorless partial?
b: Why do you need OnConfiguring removed? You can just use the constructor with a DbContextOptions class.

            var optionsBuilder = new DbContextOptionsBuilder<AssetManagementContext>();
            optionsBuilder = optionsBuilder.UseInMemoryDatabase(Guid.NewGuid().ToString());
            context = new AssetManagementContext(optionsBuilder.Options);

[jespersh]

I'll try and throw together a small example with my usage on how I intend to use it if I had to rework my persistence layer

[ErikEJ]

Don't spend too much time on it, I am not planning to make any changes to how the DbContext class is layed out, I just reuse the EF Core implementation.

[jespersh]

It'll also mostly be for my own sake to see what I've learned about working with EFCore. That others will benefit for it is a bonus 😄

[ErikEJ]

Then I had this oddity in my Aldente.Journal.Domain.csproj added:

Attempted to fix in latest daily build

[alexle1965]

Erik, this is to let you know I love your tool. I am trying out the .NET 5.0 features and I don't know how to tell the tool to move all of the Entity Configuration files to a specified directory and the same for the Result files for Stored Procedures. For the domain entities and dbContext, they are easy to do.

[ErikEJ]

@alexle1965 Please create new issues for feature suggestions or bug reports.

The Entity Configuration proposal is a duplicate of #423 .

For the Stored Procedure result files, where would you like them to be placed? - if this matters to you, please create a new feature suggestion with a proposal.

[alexle1965]

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; font-size:11.0pt; font-family:"Calibri",sans-serif;} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} .MsoChpDefault {mso-style-type:export-only;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} -->Hi Erik, Once again, thank you for the wonderful tool and I use it all the times.  My new project is to migrate a legacy application from Webforms with a lot of stored procedures to .NET Core 3.1.x.  I used your tool to do the reverse engineering and all the SProc are generated for me.  My issue is that I do not know to invoke the auto-generated stored procedures from the controllers or how they are used.  I read through the documentation but I do not see anything about using the SP. Would you be kind enough to provide me guidance of where to go for the documentation? Thank you very much.  I love your tool. Alex Le316-371-8179 (mobile)“Be more concerned with your character then your reputation…”  From: Erik Ejlskov JensenSent: Friday, November 13, 2020 12:48 AMTo: ErikEJ/EFCorePowerToolsCc: Alex Le; MentionSubject: Re: [ErikEJ/EFCorePowerTools] Update Reverse Engineering wiki page (#290) @alexle1965 Please create new issues for feature suggestions or bug reports.The Entity Configuration proposal is a duplicate of #423 .For the Stored Procedure result files, where would you like them to be placed? - if this matters to you, please create a new feature suggestion with a proposal.—You are receiving this because you were mentioned.Reply to this email directly, view it on GitHub, or unsubscribe. 

[ErikEJ]

@alexle1965 It is documented here: https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering#sql-server-stored-procedures - wonder why you were not able to find it?

[alexle1965]

Erik, Thank you very much. I clicked on the documentation link in Github as well. ⁣Alex Le 316-371-8179 Sent from BlueMail ​

…

On Feb 9, 2021, 8:13 AM, at 8:13 AM, Erik Ejlskov Jensen ***@***.***> wrote: @alexle1965 It is documented here: https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering#sql-server-stored-procedures - wonder why you were not able to find it? -- You are receiving this because you were mentioned. Reply to this email directly or view it on GitHub: #290 (comment)