Horje
querymultiple dapper c# Code Example
querymultiple dapper c#
string sql = "SELECT * FROM Invoice WHERE InvoiceID = @InvoiceID; SELECT * FROM InvoiceItem WHERE InvoiceID = @InvoiceID;";

using (var connection = My.ConnectionFactory())
{
    connection.Open();

    using (var multi = connection.QueryMultiple(sql, new {InvoiceID = 1}))
    {
        var invoice = multi.Read<Invoice>().First();
        var invoiceItems = multi.Read<InvoiceItem>().ToList();
    }
}




Csharp

Related
C# int to hex Code Example C# int to hex Code Example
c# read all files in a directory Code Example c# read all files in a directory Code Example
c# groupby date Code Example c# groupby date Code Example
Convert string int Linq Code Example Convert string int Linq Code Example
convert int to string in linq query c# Code Example convert int to string in linq query c# Code Example

Type:
Code Example
Category:
Coding
Sub Category:
Code Example
Uploaded by:
Admin
Views:
11