Apps72.Dev.Data.SqlServerClr
2.7.5
dotnet add package Apps72.Dev.Data.SqlServerClr --version 2.7.5
NuGet\Install-Package Apps72.Dev.Data.SqlServerClr -Version 2.7.5
<PackageReference Include="Apps72.Dev.Data.SqlServerClr" Version="2.7.5" />
paket add Apps72.Dev.Data.SqlServerClr --version 2.7.5
#r "nuget: Apps72.Dev.Data.SqlServerClr, 2.7.5"
// Install Apps72.Dev.Data.SqlServerClr as a Cake Addin
#addin nuget:?package=Apps72.Dev.Data.SqlServerClr&version=2.7.5
// Install Apps72.Dev.Data.SqlServerClr as a Cake Tool
#tool nuget:?package=Apps72.Dev.Data.SqlServerClr&version=2.7.5
This C# library simplify all SQL Queries to external databases, using the base class DbConnection and DotNetCore. Many implementations are compiled for SQL Server, Oracle Server or SQLite are included.
var cmd = new DatabaseCommand(mySqlConnection);
var all = cmd.ExecuteTable<Employee>();
var smith = cmd.ExecuteRow<dynamic>();
int count = cmd.ExecuteScalar<int>();
var emps = cmd.Query(" SELECT * FROM EMP WHERE EMPNO > @ID ")
.AddParameter("ID", 10)
.ExecuteTable<Employee>();
First, you need to add the .NET Core NuGet packages : https://www.nuget.org/packages/Apps72.Dev.Data.Core Many preconfigured packages are available for SQL Server, Oracle, SQLite or a generic .NET Core library: NuGet Packages.
Next, you need to create a SqlConnection or other database connection. The SqlConnection will be not closed by this library The ConnectionString will instanciated a temporary SqlConnection for this query and will be closed after using.
More on Apps72.Dev.Data Documenation.
Product | Versions |
---|---|
.NET Framework | net40 net403 net45 net451 net452 net46 net461 net462 net463 net47 net471 net472 net48 net481 |
This package has no dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.