UkrGuru.Sql 1.0.1

UkrGuru.Sql

UkrGuru.Sql is a powerful library designed to simplify interactions between .NET applications and SQL Server databases. It automatically normalizes input parameters and deserializes results, supporting dynamic queries, stored procedures, and asynchronous operations. With UkrGuru.Sql, you can access SQL Server data with minimal code and maximum performance.

Features

• Easy Integration: Seamlessly integrate with ASP.NET Core projects.
• Dynamic Queries: Support for dynamic SQL queries and stored procedures.
• Asynchronous Operations: Built-in support for async operations.
• Parameter Normalization: Automatic normalization of input parameters.
• Result Deserialization: Effortless deserialization of query results.

Installation

To use the UkrGuru.Sql library in your ASP.NET Core project, follow these steps:

1. Install the UkrGuru.Sql package from NuGet:

   dotnet add package UkrGuru.Sql
   

2. Update your appsettings.json file to include the connection string:

   {
     "ConnectionStrings": {
       "DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=YourDbName;Trusted_Connection=True;"
     }
   }
   

3. Register the UkrGuru.Sql services in your Program.cs file:

   using UkrGuru.Sql;
   
   var builder = WebApplication.CreateBuilder(args);
   builder.Services.AddScoped<IDbService, DbService>();
   
   DbHelper.ConnectionString = builder.Configuration.GetConnectionString("DefaultConnection");
   
   var app = builder.Build();
   

Samples

You can find more examples in the demos folder of this repository.

Contributing

Contributions are welcome! Please fork this repository and submit pull requests.

License

This project is licensed under the MIT License. See the LICENSE file for details.