VTNET.Vitado 1.0.0

This package has been deprecated as it has critical bugs.

There is a newer version of this package available.
See the version list below for details.

dotnet add package VTNET.Vitado --version 1.0.0

NuGet\Install-Package VTNET.Vitado -Version 1.0.0

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="VTNET.Vitado" Version="1.0.0" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="VTNET.Vitado" Version="1.0.0" />
                    

                            Directory.Packages.props

<PackageReference Include="VTNET.Vitado" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add VTNET.Vitado --version 1.0.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: VTNET.Vitado, 1.0.0"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package VTNET.Vitado@1.0.0

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=VTNET.Vitado&version=1.0.0
                    

                            Install as a Cake Addin

#tool nuget:?package=VTNET.Vitado&version=1.0.0
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

ADO.NET wrapper library

Get Table

    var data = db.GetTable(
        query: "SELECT * FROM FB_BANLE_TAM_ORDER WHERE KHOACT = @KHOACT",
        args: new("AE1567B4-640B-EE11-998C-6C2B59CACE4E")
    );    
    var data2 = db.GetTable(
        queryStored: "FB_BANLE_TAM_ORDER",
        args: 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,
        args: 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)", 
    args: 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", 
    args: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",
        args: new("AE1567B4-640B-EE11-998C-6C2B59CACE4E")
    );

Product	Compatible and additional computed target framework versions.
.NET	net7.0 is compatible. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

net7.0
- Microsoft.Extensions.Configuration (>= 7.0.0)
- Microsoft.Extensions.DependencyInjection (>= 7.0.0)
- System.Data.SqlClient (>= 4.8.5)
- VTNET.Extensions (>= 1.3.0-beta)

NuGet packages (1)

Showing the top 1 NuGet packages that depend on VTNET.Vitado:

Package	Downloads
VTNET.Vitado.SqlServer An SqlServer wrapper library	264

GitHub repositories

This package is not used by any popular GitHub repositories.

Version	Downloads	Last Updated
7.2.0	193	8/9/2024
7.2.0-beta.17	100	7/25/2024
7.2.0-beta.16	82	7/24/2024
7.2.0-beta.15	94	7/21/2024
7.2.0-beta.14	96	7/16/2024
7.2.0-beta.13	72	7/16/2024
7.2.0-beta.12	75	7/16/2024
7.2.0-beta.11	70	7/16/2024
7.2.0-beta.10	73	7/15/2024
7.2.0-beta.9	70	7/15/2024
7.2.0-beta.8.1	81	7/15/2024
7.2.0-beta.8	71	7/15/2024
7.2.0-beta.7	71	7/15/2024
7.2.0-beta.6	75	7/15/2024
7.2.0-beta.5	83	7/14/2024
7.2.0-beta.4	88	7/3/2024
7.2.0-beta.3	97	7/1/2024
7.2.0-beta.2	95	6/27/2024
7.2.0-beta.1	73	6/26/2024
7.1.0	144	5/7/2024
7.0.2	200	2/28/2024
7.0.1	224	2/21/2024
7.0.0	182	2/21/2024
2.0.10	159	1/19/2024
2.0.9	171	1/18/2024
2.0.8	209	1/15/2024
2.0.7	217	11/27/2023
2.0.6	192	11/3/2023
2.0.5	190	10/27/2023
2.0.4	169	10/27/2023
2.0.3	187	10/27/2023
2.0.2	195	10/27/2023
2.0.1	206	10/25/2023
2.0.0	199	10/12/2023
1.1.3	223	9/27/2023
1.1.2	202	9/20/2023
1.1.1	207	9/13/2023
1.1.0	209	9/13/2023
1.0.15	212	9/12/2023
1.0.14	215	9/12/2023
1.0.13	224	9/8/2023
1.0.12	249	8/25/2023
1.0.11	225	8/11/2023
1.0.10	262	8/10/2023
1.0.9	258	8/9/2023
1.0.8	253	8/9/2023
1.0.7	248	8/9/2023
1.0.6	265	8/4/2023
1.0.5	264	8/3/2023
1.0.4	268	8/3/2023
1.0.3	262	8/3/2023
1.0.2	262	8/3/2023
1.0.1	263	8/2/2023
1.0.0	268	8/2/2023