DEV Community

loading...
Cover image for Quick notes on efcore for postgres

Quick notes on efcore for postgres

bitsmonkey profile image bitsmonkey Updated on ・1 min read

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`
Enter fullscreen mode Exit fullscreen mode

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"))
        );
```
Enter fullscreen mode Exit fullscreen mode

Now Add Your ContextClass MoivesContext

```csharp
public class DdlContext : DbContext
{
    public DbSet<Movie> Movies { get; set; }

    public DdlContext(DbContextOptions<DdlContext> options) : base(options)
    {

    }       
}
```
Enter fullscreen mode Exit fullscreen mode

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");
            }
        );

    }
```
Enter fullscreen mode Exit fullscreen mode

Originally posted on Bitsmonkey
Photo by Nam Anh on Unsplash

Discussion (0)

pic
Editor guide