VTNET.Vitado 1.1.3

ADO.NET wrapper library

ASP/BLAZOR

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

Get Table

    var data = db.GetTable(
        query: "SELECT * FROM FB_BANLE_TAM_ORDER WHERE KHOACT = @KHOACT",
        paramsIn: new("AE1567B4-640B-EE11-998C-6C2B59CACE4E")
    );    
    var data2 = db.GetTable(
        queryStored: "FB_BANLE_TAM_ORDER",
        paramsIn: new("AE1567B4-640B-EE11-998C-6C2B59CACE4E")
    );

Get params out

    var paramsOut = new VitParamsOut(("@UID", 0), ("@NAME", ""));
    await db.GetParamOutAsync(
        queryStored: "[dbo].[SYS_LOGON]",
        paramsOut: paramsOut,
        paramsIn: new(("@USER", 1001), ("@PASSWD", "")));
    _ = int.TryParse(paramsOut["@UID"]?.ToString(), out var id);
    var name = paramsOut["@NAME"]?.ToString() ?? "";

Execute

    var rowAffect = await db.ExecuteAsync(
    query: "INSERT INTO Customers (Name,Email,Address) VALUES (@Name,@Email,@Address)", 
    paramsIn: new(
        ("@Name", "Võ Thành Thuận"),
        ("Email", "vothuan@vtt.com"),
        ("Address", "AG, VN")
    ));

    var rowAffect1 = await db.ExecuteAsync(query: "UPDATE Customers SET Name=@Name,Email=@Email,Address=@Address where id = @id", 
    paramsIn:new(
        ("@Name", "Võ Thành Thuận 1"),
        ("@Email", "vothuan1@vtt.com"),
        ("Address", "SG1, VN")
        ));

Render SqlCommand

    var rowAffect = await db.ExecuteAsync(VitRender.Insert("Customers", 
        ("Name", "Võ Thành Thuận"), 
        ("Email", "vothuan@vtt.com"), 
        ("Address", "AG, VN"))
            .Result);

    var rowAffect1 = await db.ExecuteAsync(VitRender.Update("Customers", 
        ("Name", "Võ Thành Thuận1"), 
        ("Email", "vothuan1@vtt.com"), 
        ("Address", "SG1, VN"))
            .AddQuery("where id = @id", ("id", 1))
            .Result);

GetTable

    var data = db.GetTable(
        query: "SELECT * FROM FB_BANLE_TAM_ORDER WHERE KHOACT = @KHOACT",
        paramsIn: new("AE1567B4-640B-EE11-998C-6C2B59CACE4E")
    );