FastEasy.SqlADO 1.0.0

FastEastSqlADO

Fast & Easy Sql ADO library

Description

Simplify and standardize your Database related code! This is a low level Sql ADO library that targets MS Sql Server databases. It takes advantage of all the methods that exists in ADO. It features robust error handling, built in logging and async methods where ADO supports them. Plus a few other useful methods.

Main methods:

• ExecuteQuery
• ExecuteScalar<T>
• ExecuteScalarAsync<T>
• ExecuteNonQuery
• ExecuteNonQueryAsync
• AddSqlServerPerformancePaging
• CreateSqlServerConnectionString
• IsConnectionOk
• IsConnectionOkAsync

Useful properties:

• DatasetResult (results are retrieved here)
• ExceptionMessageStack (full error message stack)
• IsException (verify execution)
• TimeUsedMs (how much time was spent)
• RowsAffected (rows by the latest sql statement)
• DataTables (number of datatables returned)
• SqlLogging (activate/deactivate sql logging)

Getting Started

Documentation and examples of how to use features are available in the word document in the root folder in the Git repository

Dependencies

• Microsoft.Data, Microsoft.Data.SqlClient, Newtonsoft.Json

Executing program

• Always remember to add the proper using statement after installing the nuget package.

using FastEasySqlADO;

• Execute a sql count statement

            // Create connection string
            var ConnStr = DbClient.CreateSqlServerConnectionString(
			    Server: ".", // Executing on local machine
			    Database: "TestDb",
			    Username: "TestUser",
			    Password: "TestPw"
			    );

            // Init
            DbClient Db = new(ConnStr);

            // Execute
            int PeopleFound = Db.ExecuteScalar<int>(@"SELECT COUNT(*) FROM People");

            // Output result
            Console.WriteLine($"There were {PeopleFound} people found");

• Execute 2 Sql statements and return results using parameters

            // 2 Queries
			Sql = @"SELECT FirstName, SirName FROM People WHERE FirstName LIKE @Search1;
			    SELECT * FROM People WHERE SirName LIKE @Search2;";

			// Execute statement
			Db.ExecuteQuery(Sql, new { Search1 = "%A%", Search2 = "R%" });
			
			// Handle possible exceptions and output results
			if (Db.IsException)
			{
			    Console.WriteLine($"EXCEPTION: {Db.ExceptionMessageStack}");
			}
			else 
			{
			    // Display result as Json
			    Json = Db.DatasetResult2Json(true);
			    Console.WriteLine($"DataSetResult as Json:\n{Json}");
			}

Authors

Erik Burøy

Version History

• 1.0
  • Initial Release

License

This project is licensed under the MIT License - see the LICENSE.md file for details