Code within this repository provide a base to show that work Microsoft has done to support VB.NET developers writing desktop solution with Visual Studio 2019 and higher targeting .NET Core Framework to use EF Core 5.

⚪ A mixture of simple and intermediate read samples.

⚪ No CRUD as this requires some form of mocking expect one update example in ContactsOperations.

⚪ All samples are in unit test methods

• To get started: https://github.com/efcore/EFCore.VisualBasic
• Before running code here
  • First run the following script Data script
  • Ensure all Git packages are loaded

Reverse engineering is the process of scaffolding entity type classes and a DbContext class based on a database schema. It can be performed using the Scaffold-DbContext command of the EF Core Package Manager Console (PMC) tools or the dotnet ef dbcontext scaffold command of the .NET Command-line Interface (CLI) tools. In this article, the PMC will be used, not the CLI tools method.

The following shows a simple command to create a DbContext and classes to represent data in a SQL-Server database.

Scaffold-DbContext
    "Server=.\SQLEXPRESS;Database=DateTimeDatabase;Trusted_Connection=True;"
    -Provider Microsoft.EntityFrameworkCore.SqlServer
    -t "Events","TimeTable"

Breaking down this command, the first argument indicates a server and database on the server following by - t which list the tables to scaffold. A DbContext and two classes are generated in the root folder of the current project.

A robust example Which indicates where classes are placed, in this example the following switches are used, many have both a full name and a shortcut name, for example, -v is a shortcut name for -Verbose,

Important

Running the command in a multi-project solution where there is a Windows Form and Class project generally the form project is set as the startup project. When running the command the scaffolding process will indicate the build failed as the startup project does not have the package Microsoft.EntityFrameworkCore.Tools Jump installed. To fix this in Package Manager Console select the class project in the Default project dropdown then run the command again. Note there are switches to handle this for you which will be gone over later.

Scaffold-DbContext
    "Server=.\SQLEXPRESS;Database=DateTimeDatabase;Trusted_Connection=True;"
    -Provider Microsoft.EntityFrameworkCore.SqlServer
    -OutputDir DateModels
    -Context DateTimeContext 
    -v
    -f 
    -DataAnnotations 
    -project NorthWind.Data
    -startupproject NorthWind.Data
    -ContextDir Contexts
    -t "Events","TimeTable"

In short, write out the command using the following common parameters where if there are typos or incorrectly specifying a switch or missing a switch the command will need to be modified and executed again.

Note

A developer can put together a command to reverse engineering by hand in VB.NET while this is true for C# there are tools for doing this.

For VB.NET Developers just starting out performing reverse engineering use my utility.

• Article for utility
• GitHub Source code (in C# yet is language agnostic for reverse engineering)