​

// @nuget: Dapper -Version 1.60.6

​

using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using Dapper;

​

public class Program

{   

    public static void Main()

    {

        CreateDatabase();

        InsertUser("John", true);

        InsertUser("Michael", false);

        IEnumerable<User> users = SelectUsers();

        FiddleHelper.WriteTable(users);

​

    }

    public class User

    {

        public string Name {get;set;}

        public bool Subscribed {get;set;}

    }

    public static void CreateDatabase()

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            connection.Open();

            using (var command = connection.CreateCommand())

            {

                command.CommandText = @"   

CREATE TABLE USERS

(

    USER_ID INT IDENTITY(1,1) NOT NULL,

    NAME VARCHAR(30) NULL,

    SUBSCRIBED BIT

) ";

                command.ExecuteNonQuery();

            }

        }

    }

    public static void InsertUser(string name, bool subscribed)

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            connection.Execute(insertQuery, new {name, subscribed});

        }

    }

    public static IEnumerable<User> SelectUsers()

    {

        using (var connection = new SqlConnection(FiddleHelper.GetConnectionStringSqlServer()))

        {

            return connection.Query<User>(selectQuery);

        }

    }

    //Queries:

    public static string insertQuery = @"

INSERT INTO USERS (

    NAME

,   SUBSCRIBED

) VALUES (

    @NAME

,   @SUBSCRIBED

)

";

    public static string selectQuery = @"

SELECT * FROM USERS

";

}