public static async Task<Contact> GetContactAsync(string tenant, int contactId)
{
using (var db = DbProvider.Get(FrapidDbServer.GetConnectionString(tenant), tenant).GetDatabase())
{
var sql = new Sql("SELECT * FROM website.contacts");
sql.Where("status=@0", true);
sql.And("deleted=@0", false);
sql.And("contact_id=@0", contactId);
var awaiter = await db.SelectAsync<Contact>(sql).ConfigureAwait(false);
return awaiter.FirstOrDefault();
}
}