entity framework core 2 doesn't see sqlite extensions

.net-core-2.0 entity-framework-core

Question

So with entity framework 1.1 I had entities like this

 modelBuilder.Entity<Resolution>()
      .Property(r => r.Created)
      .ValueGeneratedOnAddOrUpdate()
      .ForSqliteHasColumnType("Timestamp")            
      .ForSqliteHasDefaultValueSql("CURRENT_TIMESTAMP");

 modelBuilder.Entity<Resolution>()
      .Property(r => r.Updated)
      .ForSqliteHasColumnType("Timestamp")
      .IsRequired();

which worked fine. After upgrading to .net core 2.0 and entity framework 2.0 the

 .ForSqliteHasColumnType("Timestamp")

doesn't seem to be available anymore. In fact all "ForSqlite*" functions aren't there.

I upgraded the "Microsoft.EntityFrameworkCore.Sqlite" to 2.0. I have 

using Microsoft.EntityFrameworkCore;

Did they change something? I can't seem to find anything in the docs other then the sql providers are not backwards compatible to .NET Core 1.1.

Thanks

1
2
8/15/2017 3:47:32 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

I didn't find anywhere said about the changes. But you can use below code instead in EF Core 2.0.

.HasDefaultValueSql("CURRENT_TIMESTAMP");
2
8/15/2017 1:10:23 PM

Popular Answer

I had a similar problem after upgrading a testproject to EF Core 2.0 yesterday, in my case the database was not SQLite, but MS SQL Server.

I had to replace

 b.Property(e => e.StartDate).IsRequired().ForSqlServerHasColumnType("Date"); 
 b.Property(e => e.LastModified).IsRequired().ForSqlServerHasColumnType("SmallDateTime");

with:

 b.Property(e => e.StartDate).IsRequired().HasColumnType("Date"); 
 b.Property(e => e.LastModified).IsRequired().HasColumnType("SmallDateTime");

But after that it was working again. I tested it by recreating the database and visually checking the newly created column definitions in MS SQL Server Management Studio.

JRB

Related Questions

.net core 1.0.0 with entity framework core sqlite

I found out how to do this. The changes are based on ...https://docs.efproject.net/en/latest/miscellaneous/rc2-rtm-upgrade.html.......Change the version of the tools to 1.0.0-preview2-final...Remove the import in the frameworks section...Add a dependency to Microsoft.EntityFrameworkCore.Design...Here is the complete project.json:...{ "version": "...
.net-core c# entity-framework-core sqlite
asked by Guido Roth

Entity Framework core : DbContextOptionsBuilder' does not contain a definition for 'usesqlserver' and no extension method 'usesqlserver'

This is a known issue in the project system. See ...dotnet/project-system#1741
asp.net-core entity-framework-core
asked by bricelam

SQLite and Entity Framework Core: why include doesn't work?

I think the behaviour is expected. Did you try to invoke ToList on your selection? ...It looks like EF is ignoring include without ToList: ...Entity Framework Core ignoring .Include(..) without .ToList(..) indirectly...var list = myDbContext.People .Include(t => t.OrdersToPeople); .ToList();
c# entity-framework entity-framework-core include sqlite
asked by Willem Bijker

Why can't I use file extensions in Entity Framework Core Sqlite files?

The issue results from the previous connection still having access to the file....As mentioned in the thread below Sqlite's C# implementation has a quirk where after a .Close() the connection is not truly cleaned up until a garbage collect runs...System.Data.SQLite Close() not releasing database file...To fix it you could add IDisposable to your IA...
.net-core c# entity-framework entity-framework-core sqlite
asked by IainM1985

EF Core SQLITE - SQLite Error 19: 'UNIQUE constraint failed

Ok, i solved problems. Read some articles about EF DbContext. When i have used two other context's for GET User and CREATE message, the entities (user1 and user2) were not the same entities which i have used for second context. I mean, the entiies were this same, but they had another tracking...EF Core / Sqlite one-to-many relationship failing on U...
.net-core c# entity-framework-core sqlite
asked by SharkyShark

EF Core SQLite in memory exception: SQLite Error 1: 'near "MAX": syntax error'

I am creating SQLite In Memory database for unit testing:... var connection = new SqliteConnection("DataSource=:memory:"); connection.Open(); try { var options = new DbContextOptionsBuilder<BloggingContext>() .UseSqlite(connection) .Options; // Create the schem...
c# ef-core-2.0 ef-core-2.1 entity-framework-core sqlite
asked by Deivydas Voroneckis

Entity Framework Core - Call A Populate Extension Method Inside Include

You can create extension method for ...Student... collection itself...public static IQueryable<Student> IncludeExpertise(this IQueryable<Student> students) { return students .Include(s => s.Expertise) .ThenInclude(c => c.Teacher) .ThenInclude(p => p.License); }
c# entity-framework-6 entity-framework-core
asked by Alexander

Entity Framework Core - Use Extension Methods Inside Queryable

Try this method which will create ...Expression..., ...Package... as input and ...bool... as output:...public static System.Linq.Expressions.Expression<Func<Package, bool>> IsShippedOrInProgress() { return p => p.StatusId == ( int )PackageStatus.InProgress || p.StatusId == ( int )PackageStatus.Delivered || p.StatusId == ( ...
c# entity-framework entity-framework-core
asked by Ankush Madankar

Xamarin Forms +Entity Framework Core + SQLite - Calling migration on production breaks application

Do you have linking enabled in your release build configuration? According to this ...https://github.com/aspnet/EntityFrameworkCore/issues/10963... the compiler requires hints to not link assemblies accessed through reflection internally in EF Core. You can try switching to "Link sdk assemblies only" to see if that fixes the issue. If it does then ...
c# entity-framework-core production-environment sqlite xamarin.forms
asked by FullStackOverflowDev

ASP.NET Core + Entity Framework Core + SQLite Creating initial migration throws error

I found that in the ...DataContext... I used the wrong parameter...public DataContext(DbContextOptions<DbContext> options) : base(options) {} ...should be...public DataContext(DbContextOptions<DataContext> options) : base(options) {} ...Migration executed as expected.
asp.net-core ef-migrations entity-framework-core sqlite
asked by canvee

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow