PH.DALHelper 1.3.1

<PH.DALHelper> - What's new in the latest version

Version <1.3> This is migrate from DALHelper to support .NET Standard 2.1 and .NET Framework 4.61

This is handle query, excute from MSSQL, Oracle, Access, MySQL just simple in one Library. The result can automatic map into your Model or your custom Mapper

How to install using nuget package

Install-Package PH.DALHelper

Listing your provider

// Retrieve the installed providers and factories.
DataTable table = DbProviderFactories.GetFactoryClasses();

// Display each row and column value.
foreach (DataRow row in table.Rows)
{
	foreach (DataColumn column in table.Columns)
	{
		Console.WriteLine(row[column]);
	}
}

Using with .net core / or your Provider is not Register in your system, we can register bellow:

We need to registry Provider before going below step: Example: OleDb

DbProviderFactories.RegisterFactory("System.Data.OleDb", typeof(System.Data.OleDb.OleDbFactory));

1. Using with Instance:

var db = new DB("Provider=sqlncli11;Server=sssssssssssssssss,NNNN;Database=AAAAAAAAAAAA;Uid=zzzzzzzzzz;Pwd=qqqqqqqqqqqqqqqqqqqqqqq;Connect Timeout=180;", 180);

2. Using via PH.DALHelper

This is simple, quickly and easy to use

var msqlConnection = ConfigurationManager.ConnectionStrings["DefaultConnection"]?.ToString();
msqlConnection.CreateInstance(180); // Just create one time on your application

// And we can query everywhere
// Execute Store Procedure with param is ID and list of Categories
var res = "sp_GETcategories ?".GetObjects(new object[] { id }, new CategoryMapper());

// Excute query 		
"sp_DELETECategory ?".Execute(new object[] { id });

// Excute SQL query
var res = "SELECT ID, NAME from Customers where ID=?".GetObjects(new object[] { id }, new CustomerMapper());

// StoreProc with output, for paging, etc
object total = null;
string query = "sp_GETaaa ?, ?, ?, ?, ?, ? OUTPUT";
var res = query.GetObjects<AAA>(new object[] { id, q, offset, pageSize, orderBy, 0 }, ref total, new AAAMapper());

3. How to create CustomerMapper

public class CustomerMapper : Mapper<Customer>
{
    public override Customer Map(IDataRecord record)
    {
        var cus = new Customer();
        var idx = -1;
        
        cus.ID = record[++idx].ToString();
        cus.Name = record[++idx].ToString();        
        
        return cus;
    }
}

MySQL can following

DbProviderFactories.RegisterFactory("MySql.Data.MySqlClient", typeof(MySql.Data.MySqlClient.MySqlClientFactory));
"MySql.Data.MySqlClient".CreateInstance("server=127.0.0.1;uid=root;pwd=SQL2019-SSEI-Expr.exe;database=classicmodels", 180);

// Example query
var res = "SELECT lastName, firstName, email FROM classicmodels.employees limit 100".GetObjects<Customer>(null, new CustomerMapper());