See the version list below for details.
dotnet add package LiteX.DbHelper.SqlServer --version 3.0.0
NuGet\Install-Package LiteX.DbHelper.SqlServer -Version 3.0.0
<PackageReference Include="LiteX.DbHelper.SqlServer" Version="3.0.0" />
paket add LiteX.DbHelper.SqlServer --version 3.0.0
#r "nuget: LiteX.DbHelper.SqlServer, 3.0.0"
// Install LiteX.DbHelper.SqlServer as a Cake Addin #addin nuget:?package=LiteX.DbHelper.SqlServer&version=3.0.0 // Install LiteX.DbHelper.SqlServer as a Cake Tool #tool nuget:?package=LiteX.DbHelper.SqlServer&version=3.0.0
- CreateParameters (for each providers)
- GetDictionary<TKey, TValue>
Instantiate the DBHelper:
... // just use the connection string name IDBHelper dbHelper = new SqlHelper("MyCN"); // use different provider class based on your database.
Basic ADO.NET methods:
// Create parameters var paramResultOut = DbHelper.CreateOutParameter("@Result", SqlDbType.NVarChar, 100); var paramIsActive = DbHelper.CreateParameter("@IsActive", isActive); var paramId = DbHelper.CreateParameter("@Id", id); // ExecuteNonQuery // Stored procedure var count = _dbHelper.ExecuteNonQuery("DeleteCountry", paramIsActive, paramResultOut); // OR // Raw sql commnad var count = _dbHelper.ExecuteNonQuery("DELETE FROM [dbo].[Country] WHERE Id = @Id", CommandType.Text, paramIsActive); // ExecuteScalar - returning a object type scalar value var name = _dbHelper.ExecuteScalar("SELECT Name FROM COUNTRY"); // DataReader // Stored procedure var dataReader = _dbHelper.ExecuteReder("GetCountries", paramIsActive, paramResultOut); // OR // Raw sql commnad var dataReader = _dbHelper.ExecuteReder("SELECT * FROM Country WHERE IsActive = @IsActive", CommandType.Text, paramIsActive); // DataTable // Stored procedure var dataTable = _dbHelper.GetDataTable("GetCountries", paramIsActive, paramResultOut); // OR // Raw sql commnad var dataTable = _dbHelper.GetDataTable("SELECT * FROM Country WHERE IsActive = @IsActive", CommandType.Text, paramIsActive); // DataSet // Stored procedure var dataSet = _dbHelper.GetDataSet("GetCountriesAndStates", paramIsActive, paramResultOut);
|Product||Versions Compatible and additional computed target framework versions.|
|.NET||net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android 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.|
|.NET Core||netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.|
|.NET Standard||netstandard2.0 is compatible. netstandard2.1 was computed.|
|.NET Framework||net461 was computed. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed.|
|MonoAndroid||monoandroid was computed.|
|MonoMac||monomac was computed.|
|MonoTouch||monotouch was computed.|
|Tizen||tizen40 was computed. tizen60 was computed.|
|Xamarin.iOS||xamarinios was computed.|
|Xamarin.Mac||xamarinmac was computed.|
|Xamarin.TVOS||xamarintvos was computed.|
|Xamarin.WatchOS||xamarinwatchos was computed.|
This package is not used by any NuGet packages.
This package is not used by any popular GitHub repositories.
Upgrade to .NET Core 3.x.
Update libraries and SDKs to latest version.
Last release notes,
Advanced features (Strongly type result) - ExecuteScalar, GetSingle, GetList, GetArray, GetDictionary
DBConvert methods, DataReader, DataTable and DataTable extensions
1.0.0 - Basic featured - ExecuteNonQuery, ExecuteScalar, GetDataTable, GetDataSet, ExecuteReder, CreateParameter
Coming soon - Async methods support
Comimg soon - OUT parameter support in stored procedure
Coming soon - Ping (useful in health check and load balancing)
Coming soon - Pagination at DB server side
Coming soon - Batch execution