« Entity Framework Core 7 » : différence entre les versions
De Banane Atomic
Aller à la navigationAller à la recherche
Aucun résumé des modifications |
|||
| Ligne 1 : | Ligne 1 : | ||
[[Category:.NET Core]] | [[Category:.NET Core]] | ||
= [https://learn.microsoft.com/en-us/ef/core/get-started/overview/first-app?tabs=netcore-cli#install-entity-framework-core | = [https://learn.microsoft.com/en-us/ef/core/get-started/overview/first-app?tabs=netcore-cli#install-entity-framework-core Add Entity Framework Core package] = | ||
<kode lang='bash'> | <kode lang='bash'> | ||
# sql server | # sql server | ||
| Ligne 27 : | Ligne 27 : | ||
| Sqlite || Microsoft.EntityFrameworkCore.Sqlite || Data Source=/tmp/file.db | | Sqlite || Microsoft.EntityFrameworkCore.Sqlite || Data Source=/tmp/file.db | ||
|} | |} | ||
= [https://docs.microsoft.com/en-us/ef/core/miscellaneous/cli/dotnet Entity Framework Core Tools] = | |||
<kode lang='powershell'> | |||
# test if Entity Framework Core Tools has been installed | |||
dotnet ef | |||
# be sure to run the previous command in the folder of the project where EF has been added | |||
# dotnet ef must be installed as a global or local tool | |||
dotnet tool install --global dotnet-ef | |||
# installed in ~/.dotnet/tools | |||
# Add ~/.dotnet/tools to PATH | |||
# update | |||
dotnet tool update --global dotnet-ef | |||
</kode> | |||
{{info | Visual Studio | |||
* View → Other Windows → Package Manager Console | |||
* Default Project = the one containing the entity configurations | |||
* Startup Project = the one containing the sql server configuration}} | |||
Version du 28 juin 2023 à 21:11
Add Entity Framework Core package
|
# sql server dotnet add package Microsoft.EntityFrameworkCore.SqlServer dotnet add package Microsoft.EntityFrameworkCore.Design # mysql dotnet add package Pomelo.EntityFrameworkCore.MySql dotnet add package Microsoft.EntityFrameworkCore.Design |
Data Providers
| Provider | Package NuGet | Connection String |
|---|---|---|
| SQL Server | Microsoft.EntityFrameworkCore.SqlServer | Server=(localdb)\\MSSQLLocalDB;Database=MyDb;Integrated Security=True;MultipleActiveResultSets=True; Server=localhost;Database=MyDb;User=sa;Password=pwd; |
| MySQL / MariaDB | Pomelo.EntityFrameworkCore.MySql | server=localhost;database=MyDb;user=root;password=pwd |
| PostgreSQL | Npgsql.EntityFrameworkCore.PostgreSQL | Host=localhost;Database=MyDb;Username=root;Password=pwd |
| InMemory | Microsoft.EntityFrameworkCore.InMemory | databaseName: "test_database" |
| Sqlite | Microsoft.EntityFrameworkCore.Sqlite | Data Source=/tmp/file.db |
Entity Framework Core Tools
|
# test if Entity Framework Core Tools has been installed dotnet ef # be sure to run the previous command in the folder of the project where EF has been added # dotnet ef must be installed as a global or local tool dotnet tool install --global dotnet-ef # installed in ~/.dotnet/tools # Add ~/.dotnet/tools to PATH # update dotnet tool update --global dotnet-ef |
 |
{{{1}}} |
