mikependon

People

:bowtie:	😄 :smile:	😆 :laughing:
😊 :blush:	😃 :smiley:	☺️ :relaxed:
😏 :smirk:	😍 :heart_eyes:	😘 :kissing_heart:
😚 :kissing_closed_eyes:	😳 :flushed:	😌 :relieved:
😆 :satisfied:	😁 :grin:	😉 :wink:
😜 :stuck_out_tongue_winking_eye:	😝 :stuck_out_tongue_closed_eyes:	😀 :grinning:
😗 :kissing:	😙 :kissing_smiling_eyes:	😛 :stuck_out_tongue:

mikependon

using (var connection = new SqlConnection(connectionString))
{
    return connection.Insert<Customer, int>(customer);
}

mikependon

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (var command = connection.CreateCommand())
    {
        command.CommandText = "INSERT INTO [dbo].[Customer](Name, ..., CreatedDateUtc) VALUES (@Name, ..., @CreatedDateUtc); SELECT SCOPE_IDENTITY();";
        command.Parameters.AddWithValue("@Name", customer.Name);
        ...
        command.Parameters.AddWithValue("@CreatedDateUtc", customer.CreatedDateUtc);
        return (int)command.ExecuteScalar();

mikependon

using (var connection = new SqlConnection(connectionString))
{
    return connection.QueryAll<Customer>();
}

mikependon

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (var command = connection.CreateCommand())
    {
        command.CommandText = "SELECT Id, Name, ... FROM [dbo].[Customer];";
        var list = new List<Customer>();
        using (reader = command.ExecuteReader())
        {
            var customer = new Customer

mikependon

// Source from PostgreSQL
using (var sourceConnection = new NpgqlConnection(connectionStringToPostgreSQL))
{
    var sales = sourceConnection.QueryAll<Sale>(e => e.OrderDate >= 'FromDate' && e.OrderDate <= 'ToDate');
    
    // Destination to SQL Server
    using (var destinationConnection = new SqlConnection(connectionStringToSqlServer))
    {
        destinationConnection.BulkInsert<Sale>(sales);
    }   

mikependon

// SqlConnection
using (var connection = new SqlConnection(connectionStringToSqlServer))
{
    var customers = connection.QueryAll<Customer>();
}

// PostgreSQL
using (var connection = new NpgqlConnection(connectionStringToPostgreSQL))
{
    var sales = connection.QueryAll<Sale>();

mikependon

/* SqConnection */
var cache = CacheFactory.GetCache(); // new MemoryCache();
using (var connection = new SqlConnection(connectionString).EnsureOpen())
{
    var expirationInMinutes = 60 * 24; // 1 day
    var products = connection.Query<Product>(e => e.CustomerId == customerId,
        cacheKey: $"Customer-Product-{customerId}",
        cacheItemExpiration: expirationInMinutes,
        cache: cache);
}

mikependon

using (var context = new DatabaseContext())
{
    var customers = context
        .People
        .FromSqlRaw("SELECT * FROM [dbo].[Customer];");
}

mikependon

using (var context = new DatabaseContext())
{
    var customers = context
        .People
        .FromSqlRaw("SELECT * FROM [dbo].[Person];");
}