public static long Count(WhereDelegate <TestSuiteExecutionSummaryColumns> where, Database database = null)
{
TestSuiteExecutionSummaryColumns c = new TestSuiteExecutionSummaryColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <TestSuiteExecutionSummary>();
QuerySet query = GetQuerySet(db);
query.Count <TestSuiteExecutionSummary>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <WebHookDescriptorWebHookSubscriberColumns> where, Database database = null)
{
WebHookDescriptorWebHookSubscriberColumns c = new WebHookDescriptorWebHookSubscriberColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <WebHookDescriptorWebHookSubscriber>();
QuerySet query = GetQuerySet(db);
query.Count <WebHookDescriptorWebHookSubscriber>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <SecondaryObjectColumns> where, Database database = null)
{
SecondaryObjectColumns c = new SecondaryObjectColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <SecondaryObject>();
QuerySet query = GetQuerySet(db);
query.Count <SecondaryObject>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <PasswordFailureColumns> where, Database database = null)
{
PasswordFailureColumns c = new PasswordFailureColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <PasswordFailure>();
QuerySet query = GetQuerySet(db);
query.Count <PasswordFailure>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <DataInstancePropertyValueColumns> where, Database database = null)
{
DataInstancePropertyValueColumns c = new DataInstancePropertyValueColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <DataInstancePropertyValue>();
QuerySet query = GetQuerySet(db);
query.Count <DataInstancePropertyValue>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <AsyncExecutionRequestDataColumns> where, Database database = null)
{
AsyncExecutionRequestDataColumns c = new AsyncExecutionRequestDataColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <AsyncExecutionRequestData>();
QuerySet query = GetQuerySet(db);
query.Count <AsyncExecutionRequestData>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <ServiceRegistryLoaderDescriptorColumns> where, Database database = null)
{
ServiceRegistryLoaderDescriptorColumns c = new ServiceRegistryLoaderDescriptorColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <ServiceRegistryLoaderDescriptor>();
QuerySet query = GetQuerySet(db);
query.Count <ServiceRegistryLoaderDescriptor>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <UserIdentifierColumns> where, Database database = null)
{
UserIdentifierColumns c = new UserIdentifierColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <UserIdentifier>();
QuerySet query = GetQuerySet(db);
query.Count <UserIdentifier>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <NotificationSubscriptionColumns> where, Database database = null)
{
NotificationSubscriptionColumns c = new NotificationSubscriptionColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <NotificationSubscription>();
QuerySet query = GetQuerySet(db);
query.Count <NotificationSubscription>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <AssemblyDescriptorAssemblyReferenceDescriptorColumns> where, Database database = null)
{
AssemblyDescriptorAssemblyReferenceDescriptorColumns c = new AssemblyDescriptorAssemblyReferenceDescriptorColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <AssemblyDescriptorAssemblyReferenceDescriptor>();
QuerySet query = GetQuerySet(db);
query.Count <AssemblyDescriptorAssemblyReferenceDescriptor>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <MachineRegistriesColumns> where, Database database = null)
{
MachineRegistriesColumns c = new MachineRegistriesColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <MachineRegistries>();
QuerySet query = GetQuerySet(db);
query.Count <MachineRegistries>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <ClientServerConnectionColumns> where, Database database = null)
{
ClientServerConnectionColumns c = new ClientServerConnectionColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <ClientServerConnection>();
QuerySet query = GetQuerySet(db);
query.Count <ClientServerConnection>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static long Count(WhereDelegate <DaoReferenceObjectWithForeignKeyColumns> where, Database database = null)
{
DaoReferenceObjectWithForeignKeyColumns c = new DaoReferenceObjectWithForeignKeyColumns();
IQueryFilter filter = where (c);
Database db = database ?? Db.For <DaoReferenceObjectWithForeignKey>();
QuerySet query = GetQuerySet(db);
query.Count <DaoReferenceObjectWithForeignKey>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
/// <summary>
/// Execute a query and return the number of results
/// </summary>
/// <param name="where">A WhereDelegate that recieves a ListItemColumns
/// and returns a IQueryFilter which is the result of any comparisons
/// between ListItemColumns and other values
/// </param>
/// <param name="db"></param>
public static long Count(WhereDelegate <ListItemColumns> where, Database database = null)
{
ListItemColumns c = new ListItemColumns();
IQueryFilter filter = where (c);
Database db = database == null?Db.For <ListItem>() : database;
QuerySet query = GetQuerySet(db);
query.Count <ListItem>();
query.Where(filter);
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public static void QuerySetCount()
{
SqlClientRegistrar.Register <Item>();
QuerySet query = new QuerySet();
query.Count <Item>().Where <Bam.Net.Data.Tests.ItemColumns>(c => c.Name.StartsWith("Mort"));
query.Execute(Db.For <Item>());
long result = query.Results[0].As <CountResult>().Value;
long toCountResult = query.Results.ToCountResult(0);
Expect.AreEqual(result, toCountResult);
Out(query.Results.ToCountResult(0).ToString());
}
public static long Count(WhereDelegate <DaoReferenceObjectColumns> where, Database db = null)
{
DaoReferenceObjectColumns c = new DaoReferenceObjectColumns();
IQueryFilter filter = where (c);
QuerySet query = new QuerySet();
query.Count <DaoReferenceObject>();
query.Where(filter);
if (db == null)
{
db = Db.For <DaoReferenceObject>();
}
query.Execute(db);
return(query.Results.As <CountResult>(0).Value);
}
public void AlternativeSyntaxTest()
{
SqlClientRegistrar.Register <Item>();
Db.TryEnsureSchema <Item>();
Database db = Db.For(typeof(Item));
Item createdItem = new Item();
createdItem.Name = "Item_".RandomLetters(8);
QuerySet query = new QuerySet();
query.Insert <Item>(createdItem);
query.Select <Item>().Where <ItemColumns>(c => c.Name.StartsWith("I"));
query.Count <Item>();
query.Execute(db);
// alternative syntax
//query.Insert<Item>(createdItem)
// .Select<Item>().Where<ItemColumns>(c => c.Name.StartsWith("I"))
// .Count<Item>()
// .Execute(db);
// -- end alternative syntax
Item insertedItem = query.Results.ToDao <Item>(0);
OutLineFormat("InsertedItemId: {0}, Name: {1}", ConsoleColor.Green, insertedItem.Id, insertedItem.Name);
ItemCollection items = query.Results[1].As <ItemCollection>();
OutLine("** Item Results **", ConsoleColor.DarkYellow);
items.Each(item =>
{
OutLineFormat("Id: {0}, Name: {1}", ConsoleColor.DarkYellow, item.Id, item.Name);
});
long count = query.Results[2].As <CountResult>().Value;
OutLineFormat("Count Result: {0}", ConsoleColor.Yellow, count);
}
/// <summary>
/// 取得数据总数量
/// </summary>
/// <returns></returns>
public int Count()
{
var rst = QuerySet.Count();
return(rst);
}