DevelopmentHelpers.QueryBuilder 2.0.1

DevelopmentHelpers.QueryBuilder

DevelopmentHelpers.QueryBuilder is a common library which can be used for database queries .

Installation

Use the package manager pip to install DataTransfer.QueryBuilder.

NPM install  DevelopmentHelpers.QueryBuilder

Usage

"QueryBuilderOptions": { "SqlDataStoreOptions": { "ConnectionString": "Server=.;Database=Northwind_QueryBuilder_Test;Trusted_Connection=True;Encrypt=True;TrustServerCertificate=True;Connect Timeout=20000; pooling='true'; Max Pool Size=20000" } } Services.AddQueryBuilder(configuration); //Used Keyed service IDataStoreHelper dataStoreHelper = (IDataStoreHelper)KernelMapper.ServiceProvider.GetKeyedService(typeof(IDataStoreHelper),QueryBuilderConstants.MsSql); //or use [FromKeyedServices]

1. Create Query Query query = new() { Name = "Name", QueryType = QueryBuilder.Helpers.Enums.QueryType.Select, Statement = select, DataProviderType = QueryBuilder.Helpers.Enums.DataProviderType.MySqlClient, DataStoreType = QueryBuilder.Helpers.Enums.DataStoreType.Mssql };
2. Validate Query var (isValid,message) = await dataStoreHelper.ValidateQueryAsync(query);
3. Get Data Rows List<DataRow> rows = await dataStoreHelper.GetDataRowListAsync(query);
4. Get DataTable By Paging Models.Table dataTable = await dataStoreHelper.GetTableByPagingAsync(query, 100000);
5. Get DataTable DataTable dataTable = await dataStoreHelper.GetDataTableAsync(query);
6. Add Record List<Parameter> parameters = await dataStoreHelper.AddAsync(query);
7. Delete Record bool deleted = await dataStoreHelper.DeleteAsync(query);
8. Save Record int saved = await dataStoreHelper.SaveAsync(query);