Got to be quick :)
Add the postgres ef library to your project from Nuget.org
`dotnet add package Npgsql.EntityFrameworkCore.PostgreSQL --version 3.1.3`
Setting the efcore middleware on Startup.cs, and picking the connection string from app settings
```csharp
services.AddDbContext<DdlContext>(options =>
options.UseNpgsql(Configuration.GetConnectionString("MoviesConnection"))
);
```
Now Add Your ContextClass MoivesContext
```csharp
public class DdlContext : DbContext
{
public DbSet<Movie> Movies { get; set; }
public DdlContext(DbContextOptions<DdlContext> options) : base(options)
{
}
}
```
In case you have an existingDB which has table and column names different form your Models you can override modelling
```csharp
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Movie>(x =>
{
x.ToTable("movies_new");
x.Property(y => y.Title).HasColumnName("movie_name");
x.Property(y => y.Year).HasColumnName("movie_year");
x.Property(y => y.Rating).HasColumnName("movie_rating");
}
);
}
```
Originally posted on Bitsmonkey
Photo by Nam Anh on Unsplash
Top comments (0)