LocalDB is not supported on this Platform

Question

I'm trying to launch .Net Core 2.0 application on Ubuntu 17.04. I developed it on Windows 10 before and it works well. The problem is that when I run dotnet ef database update I get the next exception:

System.PlatformNotSupportedException: LocalDB is not supported on this Platform. 

Here is my DbContext:

public class NutritionContext : DbContext {     public DbSet<User> Users { get; set; }     public DbSet<Meal> Meals { get; set; }     public DbSet<Dish> Dishes { get; set; }     public DbSet<Product> Products { get; set; }     public DbSet<Plan> Plans { get; set; }     public DbSet<MealDish> MealDishes { get; set; }     public DbSet<Ingredient> Ingredients { get; set; }     public DbSet<PlanDetail> PlanDetails { get; set; }     public DbSet<UserPlan> UserPlans { get; set; }     public DbSet<AuthUser> AuthUsers { get; set; }      public NutritionContext()     {     }      public NutritionContext(DbContextOptions options) : base(options)     {                }      protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)     {         optionsBuilder.UseSqlServer(             "Server=(localdb)\\mssqllocaldb;Database=NutritionDatabaseNew;Trusted_Connection=True;MultipleActiveResultSets=true");     }  } 

Do you know what could be the reason of it?

Answer 1

LocalDb is a packaging mechanism for SQL Server Express Edition, and is only available for Windows. On Ubuntu you can install regular SQL Server Express Edition.

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview

Here are the install scripts for Ubuntu, Red Hat, and SUSE.

Or use the Docker Images:

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker