EFCore ASP.NET Application
Creating the Data Model
There are two approaches that can be taken in creating the context and entity classes for your application. With the Code-First Approach approach, you can fine-tune your model by writing the classes manually. Alternatively, you can make use of Reverse Engineering (Scaffolding) to generate these classes automatically from your AlloyDB schema.
Registering the Context with Dependency Injection
In order for the MVC controller to make use of the AlloyDBContext, you'll need to register it with dependency injection. Add the following to the beginning of your Startup.cs:
Next, find the ConfigureServices method in Startup.cs and add the following at the end:
var connection = @"User=alloydb;Password=admin;Database=alloydb;Server=127.0.0.1;Port=5432";
services.AddDbContext<AlloyDBContext>(options => options.UseAlloyDB(connection));
Creating a Controller and Views
To create a controller and views for your web app, follow the procedure below:
- Right-click the Controllers folder in the Solution Explorer and navigate to Add -> Controller...
- Choose MVC Controller with views, using Entity Framework, and click Add.
- Set the Model Class to the class corresponding to your table/view and set the Data context class to AlloyDBContext.
- Click Add. Note the name of the controller.
Running Your Application
Now that the controllers and views have been setup, you can launch your app using Debug -> Start Without Debugging. The app will then launch in your browser. You can find your data by navigating to <Base URL of App>/<Name of controller without the 'Controller.cs' at the end>.