using System;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using Dapper;
using Newtonsoft.Json;
namespace ConsoleApp5
{
class Program
{
static void Main()
{
using (IDbConnection db = new SqlConnection("Server=anvsqldesa;Database=sigb_anv;Trusted_Connection=true;"))
{
db.Open();
var scalar = db.Query<string>("SELECT GETDATE()").SingleOrDefault();
Console.WriteLine(scalar);
var results = db.Query<myobject>(@"SELECT TOP 1 * FROM CIF$CLI").ToList();
var xx = JsonConvert.SerializeObject(results);
Console.WriteLine(xx);
foreach (var x in results)
{
Console.WriteLine(x.numcli + " " + x.nomabr);
}
Console.ReadLine();
}
}
class myobject
{
public int numcli { get; set; }
public string nomabr { get; set; }
}
}
}
