using Dotmim.Sync;

using Dotmim.Sync.SqlServer;

using System.Data.SqlClient;

using System.Data.SQLite;

using Dapper;

​

using System;

using System.Threading.Tasks;

using System.Linq;

using System.Threading;

​

namespace HelloSync

{

    public class Shipper

    {

        public int ShipperID { get; set; }

        public string CompanyName  { get; set; }

        public string Phone { get; set; }

    }

    public class Program

    {   

        public static async Task Main()

        {

            string sql = "SELECT TOP 10 * FROM Shippers";

​

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

            {           

                var orderDetails = await connection.QueryAsync<Shipper>(sql).ConfigureAwait(false);

​

                Console.WriteLine(orderDetails.Count());

​

                FiddleHelper.WriteTable(orderDetails);

            }

        }

    private static void CreateDatabase()

    {

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

        {

            connection.Open();

            using (var command = connection.CreateCommand())

            {

            command.CommandText = @"   

CREATE TABLE Shippers (

    ShipperID int IDENTITY (1, 1) NOT NULL ,

    CompanyName nvarchar (40) NOT NULL ,

    Phone nvarchar (24) NULL ,

    CONSTRAINT PK_Shippers PRIMARY KEY  CLUSTERED

    (

        ShipperID

    )

)

GO

CREATE TABLE Suppliers (

    SupplierID int IDENTITY (1, 1) NOT NULL ,

    CompanyName nvarchar (40) NOT NULL ,

    ContactName nvarchar (30) NULL ,

    ContactTitle nvarchar (30) NULL ,

    Address nvarchar (60) NULL ,

    City nvarchar (15) NULL ,

    Region nvarchar (15) NULL ,

    PostalCode nvarchar (10) NULL ,

    Country nvarchar (15) NULL ,

    Phone nvarchar (24) NULL ,

    Fax nvarchar (24) NULL ,

    HomePage ntext NULL ,

    CONSTRAINT PK_Suppliers PRIMARY KEY  CLUSTERED

    (

        SupplierID

    )

)";

            command.ExecuteNonQuery();

            }

        }

        Console.WriteLine("GOT HERE");

    }       

    } // End of Program 

} // End of namespace