Apps72.Dev.Data
2.7.5
See the version list below for details.
dotnet add package Apps72.Dev.Data --version 2.7.5
NuGet\Install-Package Apps72.Dev.Data -Version 2.7.5
<PackageReference Include="Apps72.Dev.Data" Version="2.7.5" />
paket add Apps72.Dev.Data --version 2.7.5
#r "nuget: Apps72.Dev.Data, 2.7.5"
// Install Apps72.Dev.Data as a Cake Addin
#addin nuget:?package=Apps72.Dev.Data&version=2.7.5
// Install Apps72.Dev.Data as a Cake Tool
#tool nuget:?package=Apps72.Dev.Data&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 Compatible and additional computed target framework versions. |
---|---|
.NET Framework | net40-client is compatible. |
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.
Version | Downloads | Last updated |
---|---|---|
6.0.1 | 373 | 1/22/2024 |
5.4.3 | 6,260 | 8/3/2021 |
5.4.2 | 878 | 7/19/2021 |
5.4.1 | 873 | 6/9/2021 |
5.4.0 | 856 | 6/8/2021 |
5.3.1 | 914 | 4/20/2021 |
5.3.0 | 865 | 4/12/2021 |
5.2.0 | 845 | 4/12/2021 |
5.1.0 | 839 | 4/12/2021 |
5.0.1 | 966 | 1/25/2021 |
5.0.0 | 1,040 | 12/12/2020 |
4.2.4 | 1,173 | 10/7/2020 |
4.2.3 | 1,859 | 10/1/2020 |
4.2.2 | 987 | 9/23/2020 |
4.2.1 | 1,062 | 9/21/2020 |
4.2.0 | 998 | 9/18/2020 |
4.1.2 | 1,038 | 9/16/2020 |
4.1.1 | 4,955 | 3/18/2020 |
4.1.0 | 1,087 | 3/5/2020 |
4.0.2 | 1,145 | 1/15/2020 |
4.0.1 | 1,044 | 1/13/2020 |
4.0.0 | 1,055 | 12/29/2019 |
3.0.3 | 1,237 | 4/21/2019 |
3.0.2-rc2 | 956 | 3/28/2019 |
3.0.1-rc1 | 954 | 3/12/2019 |
3.0.1-beta | 980 | 3/5/2019 |
2.7.5 | 1,487 | 8/9/2018 |
2.7.3 | 1,391 | 7/20/2018 |
2.6.0 | 1,566 | 6/14/2018 |
2.5.0 | 1,619 | 2/11/2018 |
2.4.0 | 1,553 | 8/27/2017 |
2.3.2 | 1,525 | 7/24/2017 |
2.3.1 | 1,500 | 7/4/2017 |
2.3.0 | 1,530 | 6/23/2017 |
2.3.0-beta | 1,320 | 6/23/2017 |
2.1.0 | 1,623 | 12/17/2016 |
2.0.0 | 1,565 | 10/10/2016 |
1.5.2 | 1,734 | 3/30/2016 |
1.5.1 | 1,582 | 3/14/2016 |
1.5.0 | 1,612 | 3/14/2016 |
1.4.0 | 1,645 | 1/30/2016 |
1.3.0 | 1,944 | 1/4/2016 |
1.2.0 | 2,176 | 12/13/2015 |