// @nuget: Dapper -Version 1.60.6

// @nuget: Microsoft.SqlServer.Compact

​

using Dapper;

using System;

using System.Data.SqlClient;

using System.Linq;

public class Program

{    

    public class OrderDetail

    {

        public int OrderDetailID { get; set; }

        public int OrderID { get; set; }

        public int ProductID { get; set; }

        public int Quantity { get; set; }

    }

     public class NVJ_Escritorio

    {

        public int Id { get; set; }

        public string AppNome { get; set; }

        public string AppDominio { get; set; }

        public int AppIdInstancia { get; set; }

        public string LicenseId { get; set; }

        public string AppVersao { get; set; }

        public string AppIP { get; set; }

        public string DBNomeBase { get; set; }

        public string DBNomeServidor { get; set; }

        public string DBVersao { get; set; }

        public bool IsAtivo { get; set; }

        public string Distribuicao { get; set; }

        public Nullable<int> IdResponsavelParceria { get; set; }

        public bool EmManutencao { get; set; }

        public string Winsip { get; set; }

        public string Pais { get; set; }

        public string TranslationInterfaceConfig { get; set; }

        public string WorkflowDbServer { get; set; }

        public string WorkflowDbName { get; set; }

        public string QuoteNumber { get; set; }

        public int Renewals { get; set; }

​

    }

    public static void Main()

    {

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

​

        using (var connection = new SqlConnection("Data Source=U0174272-TPD-A;initial catalog=LegalOne_Contas;user id=novajus;password=Nplk@2012;multipleactiveresultsets=True"))

        {   

            var escritorios = connection.Query<NVJ_Escritorio>(sql).ToList();

            FiddleHelper.WriteTable(escritorios);

        }

    }

}