How do I insert data into my database using Entity Framework .NET Core?

Question

If I was using the .NET framework version of EF, I'd simply do using(var db = new dbContext()) and I'd be able to instantiate a new context and insert data using db.<tableName>.add()

However, this doesn't work for .NET core. When I attempt to instantiate a new context, I get an error message requiring that a

DbContextOptions object is passed through to the context object to instantiate it.

This is DbContext class:

public SolicitorContext(DbContextOptions<SolicitorContext> options) : base(options)
{
}

Obviously the options object needs to be passed through here to init the object.

What's your question? Yes you need to supply options to the constructor. — Tvde1
– Tvde1, Commented Oct 15, 2018 at 15:12
It has nothing to do with Full/Core frameworks. EF Core also supports parameterless constructor, just add it to your db context class, e.g. public SolicitorContext() { } — Ivan Stoev
– Ivan Stoev, Commented Oct 15, 2018 at 15:13

Askar Rayapov · Accepted Answer · 2018-10-15 15:56:25Z

2

var dbOptions = new DbContextOptionsBuilder<YOURCONTEXT>()
            .UseSqlServer(connectionString: Environment.GetEnvironmentVariable("YOURCONNSTRING"))
            .Options;

using (var yourDB = new YOURCONTEXT(dbOptions))
{
}

answered Oct 15, 2018 at 15:56

Askar Rayapov

1682 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kaffekopp · Accepted Answer · 2018-10-15 15:13:45Z

0

You can use the DbContextOptionsBuilder:

DbContextOptionsBuilder<dbContext> dbContextOptionsBuilder = new DbContextOptionsBuilder<dbContext>();
dbContextOptionsBuilder.UseSqlServer("MyConnectionString");

And pass the dbContextOptionsBuilder.Options as the parameter options when initializing your context:

using (var db = new dbContext(dbContextOptionsBuilder.Options))

answered Oct 15, 2018 at 15:13

kaffekopp

2,6299 silver badges14 bronze badges

Collectives™ on Stack Overflow

How do I insert data into my database using Entity Framework .NET Core?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related