- Sqlite Editor For Mac
- Sqlite Studio For Mac
- Sqlite Studio For Mac
- Visual Studio For Mac
- Itube Studio For Mac
- Sqlite C# Visual Studio For Mac
I am developing a cross platform (iOS / Android) app on a Mac OSX machine using Xamarin Studio. All of the Xamarin examples for local databases on mobile platforms reference SQLite and more specifically System.Data.Sqlite, etc. SQLite documentation for details on what are SQLite runtime loadable extensions. To load SQLite extension into SQliteStudio database connections, open Extension Manager: Extension manager window is similar to Collation editor window. In this tutorial, we would like to introduce you to a free GUI tool for managing SQLite databases named SQLite Studio. The SQLite studio is free, portable, intuitive, and cross-platform. It also provides some of the most important features to work with SQLite databases such as importing, exporting data in various formats including CSV, XML,.
Active1 year, 6 months ago
I've installed Visual Studio for Mac (OSX 10.12.1) today and I've been diving in quite extensively.
I wanted to try to get EntityFrameworkCore (1.1.0) to run with SQLite.
So I've created a new Console Application .NET Core and with some troubles been able to add all the necessary nuget packages. Somehow Visual Studio was not able to download the dependencies, so I had to download every dependency manually. (Maybe this solves the problem: .Net Core 1.1.0 NuGet packages fail to install in Visual Studio Mac haven't testet this yet.)
As stated in this article (https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite) I wanted to add the migration, but I couldn't find the necessary command line tool in the IDE. Did I miss something here?
Then I went on to use the .NET Core CLI to do it manually via. console. ( https://www.microsoft.com/net/core#macos). But when I execute
dotnet ef migrations add init
I get the following error.No executable found matching command 'dotnet-ef'
Was anyone able to get this to run successfully?
Community♦
Michael LopezMichael Lopez
4 Answers
Visual Studio for Mac 2017 currently (April 2017) does not support adding a reference to
Microsoft.EntityFrameworkCore.Tools.DotNet
and returns an error:You can edit the file manually and add the reference directly to the
csproj
file, as documented. Add this to your csproj file:Sqlite Editor For Mac
Then run
dotnet restore
to install the package. After that, you will be able to use dotnet ef migrations add NameOfMigration
and dotnet ef database update
scripts as per documentation.Sqlite Studio For Mac
N.B.: you must be in the project directory when executing commands.
Also see suggestion feeedback for VS 2017 for Mac:
Sqlite Studio For Mac
mihamiha2,54722 gold badges2222 silver badges3939 bronze badges
Using VS for Mac, adding those following lines into .csproj makes the migration work for me:
Packages will be automatically restored saving the .csproj from VS.
To run the 'dotnet ef' command through the terminal, you need to be in the project directory, I mean not from the directory where the .sln file is, but from the lower level.
Visual Studio For Mac
Note: Same trick with v1.0.1 of Tools.DotNet didn't work, I do not know why.
Jeremy.FJeremy.F
Check if you have this section in your project.json file and add it if it's missing.
This is valid for EF 1.1, previous version was using
Krzysztof BranickiKrzysztof BranickiMicrosoft.EntityFrameworkCore.Tools
packageItube Studio For Mac
4,26722 gold badges2828 silver badges3636 bronze badges
Without add this ItemGroup, can't add the dbcontext scaffold connection string use of cmd, so adding this in your project (Edit .csproj) first
Khushbu kadiaKhushbu kadia