SQLHelper.DB 4.0.137

dotnet add package SQLHelper.DB --version 4.0.137
NuGet\Install-Package SQLHelper.DB -Version 4.0.137
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="SQLHelper.DB" Version="4.0.137" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add SQLHelper.DB --version 4.0.137
#r "nuget: SQLHelper.DB, 4.0.137"
#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 SQLHelper.DB as a Cake Addin
#addin nuget:?package=SQLHelper.DB&version=4.0.137

// Install SQLHelper.DB as a Cake Tool
#tool nuget:?package=SQLHelper.DB&version=4.0.137

SQLHelper

Build status

SQLHelper is a simple class to help with running queries against a database.

Basic Usage

In order to use the system, you do need register it with your ServiceCollection:

serviceCollection.AddCanisterModules();
				

This is required prior to using the SQLHelper class for the first time. Once Canister is set up, you can use the SQLHelper class:

var Configuration = new ConfigurationBuilder()
            .AddInMemoryCollection()
            .Build();
var Instance = new SQLHelper(Configuration, SqlClientFactory.Instance, "ConnectionString");

Or simply ask for an instance using dependency injection:

public MyClass(SQLHelper helper) { ... }

The SQLHelper class takes in a IConfiguration class, a DbProviderFactory class, and the connection string. The connection string can just be the name of a connection string in your configuration object. Once an instance is set up, you can create a batch, add queries, and then execute them.

var Results = Instance.CreateBatch()
            		   .AddQuery(CommandType.Text,"SELECT * FROM [TestDatabase].[dbo].[TestTable]")
            		   .AddQuery(CommandType.Text,"SELECT * FROM [TestDatabase].[dbo].[TestTable2]")
            		   .AddQuery(CommandType.Text,"SELECT * FROM [TestDatabase].[dbo].[TestTable3]")
            		   .Execute();
					   

The Results object then holds the results for all 3 queries and is returned as IList<IList<dynamic>>. So in order to get the results from the queries:

var FirstQueryResults = Results[0];
var SecondQueryResults = Results[1];
var ThirdQueryResults = Results[2];

It is also possible to convert the results from the dynamic type to a class type that you specify:

var TestTableClasses = FirstQueryResults.Select(x => (TestTableClass)x).ToList();

The type will be converted automatically for you with no special type conversion required. SQLHelper also has an ExecuteScalar function:

var Result = Instance.ExecuteScalar<int>();

This will either return the first value of the first set of results OR it will return the number of rows that were effected depending on whether or not the query was a select or not.

Installation

The library is available via Nuget with the package name "SQLHelper.DB". To install it run the following command in the Package Manager Console:

Install-Package SQLHelper.DB

Build Process

In order to build the library you will require the following as a minimum:

  1. Visual Studio 2022

Other than that, just clone the project and you should be able to load the solution and build without too much effort.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (2)

Showing the top 2 NuGet packages that depend on SQLHelper.DB:

Package Downloads
Data.Modeler

Data.Modeler helps to model database schemas using C#.

Holmes

Holmes is a database analysis library designed to suggest improvements and optimizations. Supports .Net Core as well as full .Net.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
4.0.137 88 3/26/2024
4.0.136 137 3/22/2024
4.0.135 68 3/22/2024
4.0.134 185 3/18/2024
4.0.133 130 3/15/2024
4.0.132 126 3/14/2024
4.0.131 146 3/13/2024
4.0.130 139 3/11/2024
4.0.129 129 3/8/2024
4.0.128 106 3/7/2024
4.0.127 82 3/6/2024
4.0.126 95 3/5/2024
4.0.125 86 3/4/2024
4.0.124 570 3/1/2024
4.0.123 131 2/29/2024
4.0.122 81 2/28/2024
4.0.121 105 2/27/2024
4.0.120 214 2/26/2024
4.0.119 91 2/23/2024
4.0.118 92 2/22/2024
4.0.117 83 2/21/2024
4.0.116 90 2/20/2024
4.0.115 67 2/20/2024
4.0.114 537 2/19/2024
4.0.113 82 2/19/2024
4.0.112 141 2/16/2024
4.0.111 94 2/15/2024
4.0.110 95 2/14/2024
4.0.109 242 2/13/2024
4.0.108 133 2/12/2024
4.0.107 94 2/9/2024
4.0.106 154 2/8/2024
4.0.105 75 2/7/2024
4.0.104 74 2/7/2024
4.0.103 78 2/6/2024
4.0.102 517 2/2/2024
4.0.101 119 2/1/2024
4.0.100 80 2/1/2024
4.0.99 86 1/31/2024
4.0.98 80 1/30/2024
4.0.97 338 1/25/2024
4.0.96 112 1/24/2024
4.0.95 78 1/23/2024
4.0.94 931 1/16/2024
4.0.93 76 1/16/2024
4.0.92 144 1/15/2024
4.0.91 152 1/12/2024
4.0.90 90 1/11/2024
4.0.89 91 1/10/2024
4.0.88 370 1/8/2024
4.0.87 475 12/26/2023
4.0.86 79 12/26/2023
4.0.85 86 12/25/2023
4.0.84 275 12/22/2023
4.0.83 235 12/15/2023
4.0.82 89 12/14/2023
4.0.81 75 12/14/2023
4.0.80 100 12/13/2023
4.0.79 90 12/12/2023
4.0.78 631 12/11/2023
4.0.77 241 12/6/2023
4.0.76 188 12/5/2023
4.0.75 312 11/24/2023
4.0.74 203 11/21/2023
4.0.73 186 11/20/2023
4.0.72 135 11/20/2023
4.0.71 162 11/17/2023
4.0.70 261 11/16/2023
4.0.69 138 11/14/2023
4.0.68 198 11/9/2023
4.0.67 181 11/8/2023
4.0.66 154 11/7/2023
4.0.65 149 11/6/2023
4.0.64 158 11/3/2023
4.0.63 219 11/1/2023
4.0.62 100 11/1/2023
4.0.61 179 10/31/2023
4.0.60 171 10/30/2023
4.0.59 155 10/27/2023
4.0.58 152 10/26/2023
4.0.57 153 10/25/2023
4.0.56 161 10/17/2023
4.0.55 203 10/16/2023
4.0.54 220 10/12/2023
4.0.53 153 10/11/2023
4.0.52 199 10/5/2023
4.0.51 219 9/26/2023
4.0.50 219 9/22/2023
4.0.49 171 9/20/2023
4.0.48 149 9/19/2023
4.0.47 91 9/19/2023
4.0.46 189 9/18/2023
4.0.45 216 9/14/2023
4.0.44 157 9/13/2023
4.0.43 160 9/12/2023
4.0.42 201 9/11/2023
4.0.41 105 9/11/2023
4.0.40 157 9/11/2023
4.0.39 302 9/7/2023
4.0.38 169 9/6/2023
4.0.37 214 9/5/2023
4.0.36 117 9/5/2023
4.0.35 184 9/4/2023
4.0.34 221 9/1/2023
4.0.33 215 8/31/2023
4.0.32 189 8/30/2023
4.0.31 110 8/30/2023
4.0.30 218 8/29/2023
4.0.29 310 8/25/2023
4.0.28 273 8/23/2023
4.0.27 269 8/18/2023
4.0.26 176 8/17/2023
4.0.25 104 8/17/2023
4.0.24 108 8/17/2023
4.0.23 358 8/10/2023
4.0.22 199 8/9/2023
4.0.21 188 8/8/2023
4.0.20 132 8/8/2023
4.0.19 233 8/8/2023
4.0.18 292 8/7/2023
4.0.17 391 8/3/2023
4.0.16 314 7/26/2023
4.0.15 290 7/20/2023
4.0.14 282 7/18/2023
4.0.13 135 7/18/2023
4.0.12 118 7/18/2023
4.0.11 460 7/17/2023
4.0.10 133 7/14/2023
4.0.9 137 7/13/2023
4.0.8 129 7/13/2023
4.0.7 138 7/12/2023
4.0.6 134 7/12/2023
4.0.5 184 6/13/2023
4.0.4 918 1/30/2023
4.0.3 475 1/30/2023
4.0.2 475 1/27/2023
4.0.1 646 12/13/2022
4.0.0 463 12/12/2022
3.1.49 2,555 6/10/2022
3.1.47 1,737 4/20/2022
3.1.46 758 2/25/2022
3.1.45 1,931 1/11/2022
3.1.44 1,014 1/10/2022
3.1.43 1,075 10/12/2021
3.1.42 422 10/12/2021
3.1.41 1,584 6/17/2021
3.1.40 1,194 6/16/2021
3.1.39 1,087 6/16/2021
3.1.38 908 6/16/2021
3.1.37 692 6/15/2021
3.1.35 1,841 1/7/2021
3.1.34 1,290 12/16/2020
3.1.33 535 12/16/2020
3.1.32 1,114 12/14/2020
3.1.31 2,976 9/13/2020
3.1.30 1,595 6/19/2020
3.1.29 1,104 6/8/2020
3.1.28 2,314 5/12/2020
3.1.27 1,834 5/12/2020
3.1.26 1,371 4/28/2020
3.1.25 1,328 4/16/2020
3.1.23 1,266 4/16/2020
3.1.22 1,306 4/16/2020
3.1.21 1,064 4/15/2020
3.1.20 1,279 4/15/2020
3.1.19 1,354 4/14/2020
3.1.18 1,065 4/14/2020
3.1.17 577 4/14/2020
3.1.16 1,350 4/10/2020
3.1.15 1,378 4/10/2020
3.1.14 3,705 3/26/2020
3.1.13 1,391 3/26/2020
3.1.12 1,561 3/25/2020
3.1.11 1,057 3/25/2020
3.1.10 1,046 3/25/2020
3.1.9 1,495 3/25/2020
3.1.8 1,554 3/24/2020
3.1.7 2,166 3/21/2020
3.1.6 2,060 3/13/2020
3.1.5 1,076 3/13/2020
3.1.3 2,009 2/28/2020
3.1.1.2 581 2/28/2020
3.1.1 890 2/22/2020
3.1.0 1,113 2/21/2020
3.0.4 1,174 2/11/2020
3.0.3 843 2/11/2020
3.0.2 646 2/10/2020
3.0.1 1,569 1/9/2020
3.0.0 1,269 12/23/2019
2.0.18 1,895 6/19/2019
2.0.17 656 6/19/2019
2.0.16 2,019 4/17/2019
2.0.15 1,474 3/14/2019
2.0.14 715 2/22/2019
2.0.13 1,666 2/21/2019
2.0.12 686 2/21/2019
2.0.11 4,306 8/1/2018
2.0.10 1,564 8/1/2018
2.0.9 1,269 7/3/2018
2.0.8 1,708 6/26/2018
2.0.7 1,001 6/26/2018
2.0.6 1,526 6/14/2018
2.0.5 1,599 6/1/2018
2.0.4 1,901 5/22/2018
2.0.3 2,489 5/9/2018
2.0.2 2,150 2/15/2018
2.0.1 1,800 2/13/2018
2.0.0 2,495 1/2/2018
1.0.44 10,831 10/10/2017
1.0.42 903 10/10/2017
1.0.41 1,185 9/29/2017
1.0.40 4,097 9/19/2017
1.0.39 921 9/15/2017
1.0.36 909 9/15/2017
1.0.35 892 9/15/2017
1.0.34 3,106 7/3/2017
1.0.33 1,719 6/16/2017
1.0.32 1,668 6/16/2017
1.0.31 959 5/30/2017
1.0.28 1,574 5/30/2017
1.0.27 1,381 5/25/2017
1.0.26 1,604 5/24/2017
1.0.25 1,237 5/19/2017
1.0.24 960 5/19/2017
1.0.23 1,233 5/17/2017
1.0.20 1,072 5/8/2017
1.0.19 1,105 4/7/2017
1.0.18 1,625 3/22/2017
1.0.15 1,385 1/31/2017
1.0.14 1,089 1/24/2017
1.0.13 1,089 1/8/2017
1.0.12 1,056 1/6/2017
1.0.11 1,076 1/6/2017
1.0.10 1,047 1/3/2017
1.0.9 1,176 12/9/2016
1.0.8 1,019 12/1/2016
1.0.0 976 9/15/2017