GenericDataLayer_Ggt 1.0.9

About the Package:-

A generic layer for .Net, wrapping ADO.NET functionality in multiple functions which accepts SQL parameters and queries to perform CRUD operations on Microsoft SQL Server Database. Inject into a caller class and just call the methods and pass SQL parameters along with the query string and the method will return results. All methods are in async-await fashion.

Usage:-

Add in service collection as a singleton in ConfigureService Method of your Startup Class

   services.AddSingleton<IDataLayer, DataLayer>(ServiceProvider=>
    {
        return new DataLayer(Configuration, "Your ConnectionString Name from appsettings.json");
    });

The object in appsettings should look like this:

  "connectionStrings": {
                      "ConnectionName": "your connectionstring"
                       }

Add as DI in constructor :-

 IDataLayer dal;

 your_class(IDataLayer _dal)
   {
         dal=_dal;
   }

Use where you need like this:-

await dal.GeneralNonQuery(string Query); Please Not that Exceptions are not being handled on this layer, you should use ExceptionHandling middleware for centralizing exception handling.

Important Points:-

In ReadSingle(), method, the value parameter should be exactly the same as the column name which is returning the result.

In Generic Methods , T should be class, not struct.