Entity Framework 6 - Knowledge Base (KB)

Setting a DateTime Property's default value to DateTime. Now you're in the System. Default Value Attribute for ComponentModel

Does any one know how I can specify the Default value for a DateTime property using the System.ComponentModel DefaultValue Attribute?...for example I try this:...[DefaultValue(typeof(DateTime),DateTime.Now.ToString("yyyy-MM-dd"))] public DateTime DateCrea...

How Do I make a Razor Form for a complex EF Model

I am beginning to wonder if what I am about to ask is even possible.. But it SHOULD be. ...The MS examples are woefully short of what I am after so maybe EF isn't designed the way I thought. (BTW Scaffold for CRUD for each individual table works great. Bu...

.NET Core 2.1 Npgsql.EntityFrameworkCore.PostgreSQL Code-First

I create a project in which I would like to connect to an SQLite provider for testing purposes, and use PostgreSQL on production....protected override void OnConfiguring(DbContextOptionsBuilder opt) { #if DEBUG opt.UseSqlite("Data Source=blogging.db");...

No database provider has been configured for this DbContext in ASP.NET Core 2.1

I get this error:...InvalidOperationException: No database provider has been configured for this DbContext. A provider can be configured by overriding the DbContext.OnConfiguring method or by using AddDbContext on the application service provider. If AddD...

MapToStoredProcedures not available

I saw a few questions related to this on stack overflow but none of them helped. I am using VS 2019 community edition, I created an API project on .NetCore 2.1, and added the following nuget packages. (assuming all EF packages will be included by default)...