OX.DataAccess
2.1.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 OX.DataAccess --version 2.1.3
NuGet\Install-Package OX.DataAccess -Version 2.1.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="OX.DataAccess" Version="2.1.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add OX.DataAccess --version 2.1.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: OX.DataAccess, 2.1.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 OX.DataAccess as a Cake Addin #addin nuget:?package=OX.DataAccess&version=2.1.3 // Install OX.DataAccess as a Cake Tool #tool nuget:?package=OX.DataAccess&version=2.1.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
OX.DataAccess 2.1.3 Only for MSSQL
Example
public Class DB
{
public void getAll()
{
//getting many rows
List<Users> users = ExecSp<ResponseUser>(connectionStr,"ope.StoredProcedureName",
reader =>
{
return new ResponseUser
{
Name = reader["Name"].ToString(),
LastName = reader["LastName"].ToString()
age = Convert.ToInt32(reader["age"].ToString())
};
}).ToList();
}
public void New(Person person)
{
//getting 1 row
Response = ExecSp<Response>(connectionStr,"dbo.StoredProcedureName", data.ToSqlParameters(person),
reader =>
{
return new Response
{
Code = reader["Code"].ToString(),
Message = reader["Message"].ToString()
};
}).FirstOrDefault();
}
//execute sotered procedure Without parameters
public void New(Person person)
{
var result = data.ExecSp<Response>(connectionStr, "dbo.StoredProcedureName",
reader =>
{
return new Response
{
Code = reader["Code"].ToString(),
Message = reader["Message"].ToString()
};
}).FirstOrDefault();
}
//execute stored procedure without data response, Sql parameters are optional
public void New()
{
int query = ExecSp(connectionStr, "dbo.StoredProcedureName"); //returns the number of rows affected
}
//When stored procedure returns 2 or more data sets
public void GetData()
{
DataSet ds;
ExecSp(_connectionStr, "dbo.StoredProcedureName", data.ToSqlParameters(entity), ref ds);
//
employes = data.ToEntity<Employe>(ds,0,
reader =>
{
return new Employe
{
Name = reader["Name"].ToString(),
LastName = reader["LastName"].ToString(),
Department = reader["Department"].ToString(),
};
}).ToList();
}
}
//Conversion types properties to SqlParameter (C# to SQL)
class Person
{
int var1 {get; set;} //SQl = int
string var2 {get; set;} //SQl = varchar
bool var3 {get; set;} //SQl = bit
long var4 {get; set;} //SQl = bigint
char var5 {get; set;} //SQl = char
DateTime var6 {get; set;} //SQl = DateTime
byte[] var7 {get; set;} //SQl = varbinary
decimal var8 {get; set;} //SQl = decimal
}
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.Data.SqlClient (>= 5.1.4)
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 | |
---|---|---|---|
2.1.4 | 194 | 4/2/2024 | |
2.1.3 | 130 | 2/7/2024 | |
2.1.2 | 116 | 1/22/2024 | |
2.1.1 | 112 | 1/21/2024 | |
2.1.0 | 121 | 1/18/2024 | |
2.0.9 | 117 | 1/11/2024 | |
2.0.8 | 103 | 1/11/2024 | |
2.0.7 | 102 | 1/11/2024 | |
2.0.6 | 135 | 1/7/2024 | |
2.0.5 | 124 | 1/7/2024 | |
2.0.3 | 130 | 1/7/2024 | |
2.0.1 | 126 | 1/7/2024 | |
1.0.4 | 140 | 1/5/2024 | |
1.0.1 | 135 | 1/4/2024 |
Added a method to convert a DataTable to Entity