Frapid.Mapper.Sql.And C# (CSharp) Method

And() public method

public And ( string token ) : Sql
token string
return Sql
        public Sql And(string token, params object[] args)
        {
            token = this.ProcessToken(token);
            return this.Append(new Sql("AND (" + token + ")", args));
        }

Usage Example

Ejemplo n.º 1
0
 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();
     }
 }
All Usage Examples Of Frapid.Mapper.Sql::And