public static void Save(Account account, PersistenceConnection connection = null) { Queries.Save.Start() .Param <Account>("account", account) .Connect(connection) .Execute(); }
public static void Save(IEnumerable <Account> accounts, PersistenceConnection connection = null) { Queries.Save.Start() .Batch <Account>(accounts, "account") .Connect(connection) .Execute(); }
public static EdgeField Get(int fieldID, PersistenceConnection connection = null) { return(Queries.GetByID.Start() .Param <int>("fieldID", fieldID) .Connect(connection) .Execute() .FirstOrDefault() ); }
public static Channel Get(int channelID, PersistenceConnection connection = null) { var results = Queries.Get.Start() .Input <int>("channelID", channelID) .Connect(connection) .Execute(); Channel result = null; foreach (Channel r in results) { result = r; break; } return(result); }
public static IEnumerable <Measure> GetInstances(int accountID, FlagsQuery?options = null, PersistenceConnection connection = null) { return(GetInstances(new Account() { ID = accountID }, options, connection)); }
public static IEnumerable <Measure> GetInstances(Account account = null, FlagsQuery?options = null, PersistenceConnection connection = null) { return(Measure.Queries.GetInstances.Start() .Param <Account>("account", account) .Param <FlagsQuery?>("options", options) .Execute()); }
public static IEnumerable <EdgeField> Get(int accountID = -1, int channelID = -1, PersistenceConnection connection = null) { return(Queries.Get.Start() .Param <int>("accountID", accountID) .Param <int>("channelID", channelID) .Connect(connection) .Execute() ); }
public static IEnumerable <Account> Get(int accountID = -1, bool flat = false, PersistenceConnection connection = null) { var results = Queries.Get.Start() .Param <int>("accountID", accountID) .Connect(connection) .Execute(); if (flat) { return(results); } else { return(results.Where(account => account.ParentAccount == null)); } }
protected virtual Query OnPrepare(PersistenceConnection connection) { return(new Query(this, connection)); }
public Query Prepare(PersistenceConnection connection = null) { return(OnPrepare(connection)); }
public static IEnumerable <EdgeType> Get(Account account = null, Channel channel = null, PersistenceConnection connection = null) { return(Queries.Get.Start() .Param <Account>("account", account) .Param <Channel>("channel", channel) .Connect(connection) .Execute()); }
public static IEnumerable <Measure> Get(Account account = null, Channel channel = null, PersistenceConnection connection = null) { return(Measure.Queries.Get.Start() .Select( Measure.Properties.Name, Measure.Properties.DisplayName, Measure.Properties.TEMPConnections ) .Param <Account>("account", account) .Param <Channel>("channel", channel) .Filter(Measure.Properties.DataType, " = ", MeasureDataType.Currency) .Execute(QueryExecutionMode.Buffered)); }
public static IEnumerable <Channel> Get(PersistenceConnection connection = null) { return(Queries.Get.Start() .Connect(connection) .Execute()); }
public override PersistenceAdapter GetAdapter(PersistenceConnection connection) { return(new SqlTextCommandAdapter((SqlPersistenceConnection)connection, this)); }
internal Query(QueryDefinition definition, PersistenceConnection connection) { _definition = definition; _connection = connection; }