Fx.Data.SQL
0.0.3
There is a newer version of this package available.
See the version list below for details.
See the version list below for details.
dotnet add package Fx.Data.SQL --version 0.0.3
NuGet\Install-Package Fx.Data.SQL -Version 0.0.3
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Fx.Data.SQL" Version="0.0.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Fx.Data.SQL --version 0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Fx.Data.SQL, 0.0.3"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install Fx.Data.SQL as a Cake Addin #addin nuget:?package=Fx.Data.SQL&version=0.0.3 // Install Fx.Data.SQL as a Cake Tool #tool nuget:?package=Fx.Data.SQL&version=0.0.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Fx.Data.SQL
Supports
- SQL Server
- MySQL
- SQLite
- PostgreSQL
How to use?
Install-Package Fx.Data.SQL
Code to Initialize SQL Server
Initialization on SQL Server
IEntityService _entityService;
SqlConnection sqlServerConnection = new SqlConnection(connString);
_entityService = new SQLEntityService(sqlServerConnection, logger);
Initialization on PostgreSQL
IEntityService _entityService;
NpgsqlConnection sqlServerConnection = new NpgsqlConnection(ConnectionString);
_entityService = new SQLEntityService(sqlServerConnection, logger);
Initialization on SQLite
IEntityService _entityService;
SQLiteConnection sqlServerConnection = new SQLiteConnection(ConnectionString);
_entityService = new SQLEntityService(sqlServerConnection, logger);
Initialization on MySQL
IEntityService _entityService;
MySqlConnection sqlServerConnection = new MySqlConnection(ConnectionString);
_entityService = new SQLEntityService(sqlServerConnection, logger);
Execution, never changes
var userDetails = _entityService.GetById("User", "1");
string json = JsonSerializer.Serialize(userDetails);
Console.WriteLine($"Resulted Record {json}");
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- Microsoft.AspNetCore.Http.Abstractions (>= 2.2.0)
- Microsoft.Extensions.Logging.Abstractions (>= 8.0.1)
- RepoDb.MySql (>= 1.13.1)
- RepoDb.PostgreSql (>= 1.13.1)
- RepoDb.PostgreSql.BulkOperations (>= 1.13.1)
- RepoDb.Sqlite.Microsoft (>= 1.13.1)
- RepoDb.SqlServer (>= 1.13.1)
- RepoDb.SqlServer.BulkOperations (>= 1.13.1)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.