c# - Using Entity Framework on Ubuntu 16.04 -

i have created asp.net core mvc application hosted on ubuntu linux server. website runs , works properly.

today added entity framework project. can post data database , retrieve on windows machine, working.

when move project ubuntu machine, website works when try access pages require database error:

platformnotsupportedexception: localdb not supported on platform. system.data.sqlclient.sni.localdb.getlocaldbconnectionstring(string localdbinstance) 

am missing entity framework/sql_server packages on ubuntu machine or there cause?

take @ error message:

platformnotsupportedexception: localdb not supported on platform.

which means, localdb not supported on linux.

also see this issue on github:

as @erikej said, localdb windows only. on linux, can use ef core remote sql server (running on windows), preview version of https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview, or sql azure. alternatively, can use postgres , sqlite providers.

so in summary, need database.