VTNET.Vitado 2.0.0

ADO.NET Wrapper Library

Introduction

This library is designed to simplify ADO.NET interactions by wrapping around ADO.NET and using the SqlDataReader class to read data. It provides a set of methods for executing queries and stored procedures and mapping the results to objects, making database interactions in your .NET applications more straightforward and efficient.

Commands

The library offers a variety of commands to execute and interact with your database:

Query

• Query: Execute a query and return the number of affected rows.
• Query<T>: Execute a query and return a list of mapped data.
• QueryAsync: Asynchronously execute a query and return the number of affected rows.
• QueryAsync<T>: Asynchronously execute a query and return a list of mapped data.
• QueryTable: Execute a query and return the result as a DataTable.
• QueryTableAsync: Asynchronously execute a query and return the result as a DataTable.
• QueryFirst<T>: Execute a query and return the first row as a mapped object.
• QueryFirstAsync<T>: Asynchronously execute a query and return the first row as a mapped object.
• QueryOne<T>: Execute a query and return the first cell of the first row as a mapped object.
• QueryOneAsync<T>: Asynchronously execute a query and return the first cell of the first row as a mapped object.

Stored Procedure

• Stored: Execute a stored procedure and return the number of affected rows.
• Stored<T>: Execute a stored procedure and return a list of mapped data.
• StoredAsync: Asynchronously execute a stored procedure and return the number of affected rows.
• StoredAsync<T>: Asynchronously execute a stored procedure and return a list of mapped data.
• StoredTable: Execute a stored procedure and return the result as a DataTable.
• StoredTableAsync: Asynchronously execute a stored procedure and return the result as a DataTable.
• StoredFirst<T>: Execute a stored procedure and return the first row as a mapped object.
• StoredFirstAsync<T>: Asynchronously execute a stored procedure and return the first row as a mapped object.
• StoredOne<T>: Execute a stored procedure and return the first cell of the first row as a mapped object.
• StoredOneAsync<T>: Asynchronously execute a stored procedure and return the first cell of the first row as a mapped object.

Integration with ASP/Blazor

You can easily integrate this library into your ASP.NET or Blazor applications. To get started, add the following code to your Startup.cs or Program.cs:

builder.Services.AddVitado("Data Source=.;Initial Catalog=...;MultipleActiveResultSets=True;User Id=...;Password=...");

Make sure to replace the connection string with your specific database details.

How to Use

Query

Here are examples of how to use the library for querying:

// Query and map data
List<DBOrderTable> fbBanLeTam = await db.QueryAsync<DBOrderTable>("SELECT * FROM [dbo].[FB_BANLE_TAM]");
DBOrderTable fbBanLeTam = await db.QueryFirstAsync<DBOrderTable>("SELECT TOP 1 * FROM [dbo].[FB_BANLE_TAM]");
string name = await db.QueryOneAsync<string>("SELECT TOP 1 * FROM [dbo].[FB_BANLE_TAM]");

// Parameters
var inforUser = await db.QueryFirstAsync<DB_SYS_USER>(
    query: "SELECT [UserName], [FullName], [Email], [PassWD], [UID], [Is_Employee], [Manv], [Must_Chg_Pwd] FROM [ERP_SOFTZ].[dbo].[SYS_USER] WHERE UID = @UID",
    paramsIn: new(("@UID", 241))
);

Stored Procedure

For using stored procedures, follow these examples:

// Query and map data
List<DBOrderTable> fbBanLeTam = await db.StoredAsync<DBOrderTable>("[dbo].[SYS_ReportParams]");
DBOrderTable fbBanLeTam = await db.StoredFirstAsync<DBOrderTable>("[dbo].[SYS_ReportParams]");

// Parameters
var inforUser = await db.QueryFirstAsync<DB_SYS_USER>(
    stored: "[dbo].[SYS_ReportParams]",
    paramsIn: new(("@UID", 241))
);

// Parameters with Output
var dataStored1 = db.StoredTable("[dbo].[SYS_ReportParams]", new(("@UID", 241), ("CODE", "NV1001")), new(("@Name", ""), ("@TestOutParams", 0)));

// Execute stored procedures without regard to parameters
var vitParamsAuto = db.StoredParams("[dbo].[SYS_ReportParams]").ToVitParamsAuto();
var dataStored2 = db.StoredTable("[dbo].[SYS_ReportParams]", vitParamsAuto.Item1, vitParamsAuto.Item2);

Get Parameters Of Stored Procedure And Mapping Type

var vitParams = db.StoredParams("[dbo].[SYS_ReportParams]");
foreach (var item in vitParams)
{
    var type = item.Type.GetTypeMap(); // mapping SqlDbType to Type
    var defaultValue = type.GetDefaultValue(); // get default value of type
    Console.WriteLine($"Type:{type}, ValueDefault:{defaultValue}");
}

You can now seamlessly work with your database using this ADO.NET wrapper library, saving time and effort in your .NET applications.