VTNET.Vitado 1.0.0

.NET 7.0 This package targets .NET 7.0. The package is compatible with this framework or higher.
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
                    


                    

                
#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

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. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

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

Package Downloads
VTNET.Vitado.SqlServer

An SqlServer wrapper library

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
7.2.0 270 8/9/2024
7.2.0-beta.17 142 7/25/2024
7.2.0-beta.16 122 7/24/2024
7.2.0-beta.15 124 7/21/2024
7.2.0-beta.14 146 7/16/2024
7.2.0-beta.13 103 7/16/2024
7.2.0-beta.12 110 7/16/2024
7.2.0-beta.11 104 7/16/2024
7.2.0-beta.10 110 7/15/2024
7.2.0-beta.9 99 7/15/2024
7.2.0-beta.8.1 117 7/15/2024
7.2.0-beta.8 102 7/15/2024
7.2.0-beta.7 109 7/15/2024
7.2.0-beta.6 110 7/15/2024
7.2.0-beta.5 127 7/14/2024
7.2.0-beta.4 135 7/3/2024
7.2.0-beta.3 145 7/1/2024
7.2.0-beta.2 127 6/27/2024
7.2.0-beta.1 103 6/26/2024
1.0.0 323 8/2/2023 1.0.0 is deprecated because it has critical bugs.
Loading failed