dotnet add package LiteX.DbHelper.SqlServer --version 4.0.0
NuGet\Install-Package LiteX.DbHelper.SqlServer -Version 4.0.0
<PackageReference Include="LiteX.DbHelper.SqlServer" Version="4.0.0" />
paket add LiteX.DbHelper.SqlServer --version 4.0.0
#r "nuget: LiteX.DbHelper.SqlServer, 4.0.0"
// Install LiteX.DbHelper.SqlServer as a Cake Addin #addin nuget:?package=LiteX.DbHelper.SqlServer&version=4.0.0 // Install LiteX.DbHelper.SqlServer as a Cake Tool #tool nuget:?package=LiteX.DbHelper.SqlServer&version=4.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 is compatible. 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.|
|.NET Core||netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 is compatible.|
|.NET Standard||netstandard2.0 is compatible. netstandard2.1 is compatible.|
|.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 5.x.
Added multi-framework target support - .NET 5, .NET Core 3.1, .NET Standard 2.1 and .NET Standard 2.0
Update libraries and SDKs to latest version.
Last releases 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