BlitzkriegSoftware.AdoSqlHelper
1.0.0
dotnet add package BlitzkriegSoftware.AdoSqlHelper --version 1.0.0
NuGet\Install-Package BlitzkriegSoftware.AdoSqlHelper -Version 1.0.0
<PackageReference Include="BlitzkriegSoftware.AdoSqlHelper" Version="1.0.0" />
paket add BlitzkriegSoftware.AdoSqlHelper --version 1.0.0
#r "nuget: BlitzkriegSoftware.AdoSqlHelper, 1.0.0"
// Install BlitzkriegSoftware.AdoSqlHelper as a Cake Addin
#addin nuget:?package=BlitzkriegSoftware.AdoSqlHelper&version=1.0.0
// Install BlitzkriegSoftware.AdoSqlHelper as a Cake Tool
#tool nuget:?package=BlitzkriegSoftware.AdoSqlHelper&version=1.0.0
SqlHelperCore
SQL Helpers for .NET Core. For doing quick operations against SQL Server using ADO.
SQL Express 2017
The unit tests need a SQL Instance to test against. We have set it up to test against SQL Express 2017 (Developer).
Download: https://www.microsoft.com/en-us/download/details.aspx?id=55994
There is a start-up script for SQL-Express if needed Start-SQLExpress.cmd
Methods
Stored Procedure
ExecuteStoredProcedureWithDataTable
- Execute a stored procedure with parameters and return a data table
ExecuteStoredProcedureWithNoReturn
- Execute a stored procedure with parameters with no return
ExecuteStoredProcedureWithParametersToScaler
- Execute a stored procedure with parameters and return a scaler value
Dynamic SQL
ExecuteSqlWithParametersNoReturn
- Execute SQL with parameters no return
ExecuteSqlWithParametersToDataTable
- Execute SQL with parameters to a data table
ExecuteSqlWithParametersToScaler
- Execute SQL with parameters to a scaler value
Helpers
HasRows
- does a data table have rows
HasTables
- does a data set have tables
FixSqlInText
- Fixes comma separated lists to be quoted correctly and removes last list delimiter for SQL 'IN' clauses
CleanParameters
- Clean a list of SQL Parameters to fix up strings by calling
SqlTextClean()
for each parameter that is NText, NVarChar, Test, VarChar.
- Clean a list of SQL Parameters to fix up strings by calling
SqlTextClean
- Fix unmatched
'
characters
- Fix unmatched
ParameterBuilder
- Quick helper to build a
SqlParameter
with a value set
- Quick helper to build a
Test Dabase: Zoo
A little test database Zoo.mdf
is provided to serve as the bed for testing. It is attached for testing to the SQL Express Environment.
The test framework attaches and detaches the DB as part of the testing.
License
Copyright (c) 2018-2019 Licensed under the MIT license.
About me
Stuart Williams
- I Cloud. I Code.
- <a href="mailto:stuart.t.williams@outlook.com" target="_blank">stuart.t.williams@outlook.com</a> (e-mail)
- Blog: <a href="http://blitzkriegsoftware.net/Blog" target="_blank">http://blitzkriegsoftware.net/Blog</a>
- LinkedIn: <a href="http://lnkd.in/P35kVT" target="_blank">http://lnkd.in/P35kVT</a>
- YouTube: <a href="https://www.youtube.com/user/spookdejur1962/videos" target="_blank">https://www.youtube.com/user/spookdejur1962/videos</a>
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-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. |
.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. |
-
.NETStandard 2.0
- System.Data.SqlClient (>= 4.6.1)
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 |
---|
This is a port of the .NET Classic Version