public void Remove(T obj) { String sqlCommand; SqlParameter[] parameters; sqlCommand = @"DELETE FROM " + RelationshipTableName + " WHERE " + ChildKeyColumnName + " = @" + ChildKeyColumnName + " AND " + ParentKeyColumnName + " = @" + ParentKeyColumnName; parameters = new SqlParameter[] { new SqlParameter(ParentKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(_parentObject.ActiveRecordMap.PrimaryKeyColumnMap.Property.PropertyType) , _parentObject.Id), new SqlParameter(ChildKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(ActiveRecord <T> .GetMap().PrimaryKeyColumnMap.Property.PropertyType) , obj.Id) }; //Execute Delete Command ActiveRecordSession.GetSession().DatabaseServices.ExecuteNonQuery(sqlCommand, parameters); ObjectList.Remove(obj); _retrivedObjects.Remove(obj.Id); }
public static T Find(long id) { if (id == null) { return(null); } ActiveRecordMap activeRecordMap = ActiveRecord <T> .GetMap(); string query = @"SELECT " + SqlBuilderServices.BuildSqlColumnList(activeRecordMap.ColumnList(true), activeRecordMap.TableName, SqlBuilderServices.ColumnListType.List) + " FROM " + activeRecordMap.TableName + " WHERE " + activeRecordMap.PrimaryKeyColumnName + " = @" + activeRecordMap.PrimaryKeyColumnName; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(activeRecordMap.PrimaryKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(activeRecordMap.PrimaryKeyColumnMap.Property.PropertyType) , id) }; IDataReader dataReader = _activeRecordSession.DatabaseServices.ExecuteDataReader(query, parameters); return(ObjectRetrievalServices.RetrieveObject <T>(dataReader, activeRecordMap)); }
public void SetToIds(List <long> ids) { List <T> newObjectList = new List <T>(); List <T> objectsToRemoveList = new List <T>(); foreach (long id in ids) { newObjectList.Add(ActiveRecord <T> .Find(id)); } foreach (T obj in ObjectList) { if (!newObjectList.Contains(obj)) { objectsToRemoveList.Add(obj); } } foreach (T obj in objectsToRemoveList) { Remove(obj); } foreach (T obj in newObjectList) { if (!ObjectList.Contains(obj)) { ObjectList.Add(obj); } } }
protected override void Retrieve() { String sqlQuery; SqlParameter[] parameters; sqlQuery = @"SELECT " + SqlBuilderServices.BuildSqlColumnList(ActiveRecord <T> .GetMap().ColumnList(true), ActiveRecord <T> .GetMap().TableName, SqlBuilderServices.ColumnListType.List) + " FROM " + ActiveRecord <T> .GetMap().TableName + " INNER JOIN " + RelationshipTableName + " ON " + RelationshipTableName + "." + ChildKeyColumnName + " = " + ActiveRecord <T> .GetMap().TableName + "." + ChildKeyColumnName + " WHERE " + ParentKeyColumnName + " = @" + ParentKeyColumnName; parameters = new SqlParameter[] { new SqlParameter(ParentKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(_parentObject.ActiveRecordMap.PrimaryKeyColumnMap.Property.PropertyType) , _parentObject.ActiveRecordMap.PrimaryKeyColumnMap.Property.GetValue(_parentObject, null)) }; ObjectList = ActiveRecord <T> .FindManyWithSql(sqlQuery, parameters); foreach (T obj in ObjectList) { _retrivedObjects.Add(obj.Id); } _loadStatus = LoadStatuses.Loaded; }
public static List <T> FindManyWithSql(String sqlQuery) { ActiveRecordMap activeRecordMap = ActiveRecord <T> .GetMap(); IDataReader dataReader = _activeRecordSession.DatabaseServices.ExecuteDataReader(sqlQuery); return(ObjectRetrievalServices.RetrieveObjects <T>(dataReader, activeRecordMap)); }
public static List <T> FindAll() { ActiveRecordMap activeRecordMap = ActiveRecord <T> .GetMap(); string query = @"SELECT " + SqlBuilderServices.BuildSqlColumnList(activeRecordMap.ColumnList(true), activeRecordMap.TableName, SqlBuilderServices.ColumnListType.List) + " FROM " + activeRecordMap.TableName; IDataReader dataReader = _activeRecordSession.DatabaseServices.ExecuteDataReader(query); return(ObjectRetrievalServices.RetrieveObjects <T>(dataReader, activeRecordMap)); }
public static T FindFirstWhere(String where, SqlParameter[] parameters) { ActiveRecordMap activeRecordMap = ActiveRecord <T> .GetMap(); string query = @"SELECT " + SqlBuilderServices.BuildSqlColumnList(activeRecordMap.ColumnList(true), activeRecordMap.TableName, SqlBuilderServices.ColumnListType.List) + " FROM " + activeRecordMap.TableName + " WHERE " + where; IDataReader dataReader = _activeRecordSession.DatabaseServices.ExecuteDataReader(query, parameters); return(ObjectRetrievalServices.RetrieveObject <T>(dataReader, activeRecordMap)); }
protected override void Retrieve() { String where; SqlParameter[] parameters; where = ChildKeyColumnName + " = @" + ParentKeyColumnName; parameters = new SqlParameter[] { new SqlParameter(ParentKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(ActiveRecord <T> .GetMap().PrimaryKeyColumnMap.Property.PropertyType) , _parentObject.ActiveRecordMap.ColumnMappings[ParentKeyColumnName].Property.GetValue(_parentObject, null)) }; ObjectList = ActiveRecord <T> .FindManyWhere(where, parameters); _loadStatus = LoadStatuses.Loaded; }
public void Refresh() { ActiveRecordMap activeRecordMap = ActiveRecord <T> .GetMap(); string query = @"SELECT " + SqlBuilderServices.BuildSqlColumnList(activeRecordMap.ColumnList(true), activeRecordMap.TableName, SqlBuilderServices.ColumnListType.List) + " FROM " + activeRecordMap.TableName + " WHERE " + activeRecordMap.PrimaryKeyColumnName + " = @" + activeRecordMap.PrimaryKeyColumnName; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter(activeRecordMap.PrimaryKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(activeRecordMap.PrimaryKeyColumnMap.Property.PropertyType) , this.Id) }; IDataReader dataReader = _activeRecordSession.DatabaseServices.ExecuteDataReader(query, parameters); ObjectRetrievalServices.RetrieveObject <T>(dataReader, activeRecordMap, true); }
private void Initialize() { if (!_activeRecordSession.ActiveRecordCache.ContainsKey(typeof(T))) { _activeRecordSession.ActiveRecordCache.Add(typeof(T), new Dictionary <object, object>()); } if (_activeRecordMap == null) { _activeRecordMap = ActiveRecord <T> .GetMap(); } InitializeRelationships(); _objectStatus = ObjectStatus.New; if (_activeRecordMap.PrimaryKeyColumnMap != null) { _activeRecordMap.PrimaryKeyColumnMap.Property.SetValue(this, -1, null); } }
public override void Save() { String where; SqlParameter[] parameters; //TODO: Change to foreach ala Has object if (ObjectList.Count > 0) { if (ObjectList[0] != null && ObjectList[0].Version <= _parentObject.Version) { ObjectList[0].Save(); } //Set the parent's foreign key value to the child's primary key value _parentObject.ActiveRecordMap.ColumnMappings[ParentKeyColumnName].Property.SetValue(_parentObject, ActiveRecord <T> .GetMap().PrimaryKeyColumnMap.Property.GetValue(ObjectList[0], null), null); } }
public override void Save() { String where; SqlParameter[] parameters; foreach (T obj in ObjectList) { //Set each child's foreign key to the parent's primary key if (obj.Version < _parentObject.Version) { obj.Save(); } //Insert relationship row for newly added/created child objects if (!_retrivedObjects.Contains(obj.Id)) { string command = @"INSERT INTO " + RelationshipTableName + "(" + ParentKeyColumnName + "," + ChildKeyColumnName + ")" + " VALUES(@" + ParentKeyColumnName + ", @" + ChildKeyColumnName + ")"; parameters = new SqlParameter[] { new SqlParameter(ParentKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(_parentObject.ActiveRecordMap.PrimaryKeyColumnMap.Property.PropertyType) , _parentObject.Id), new SqlParameter(ChildKeyColumnName , SqlBuilderServices.GetDBTypeFromSystemType(ActiveRecord <T> .GetMap().PrimaryKeyColumnMap.Property.PropertyType) , obj.Id) }; //Execute Insert Command ActiveRecordSession.GetSession().DatabaseServices.ExecuteNonQuery(command, parameters); _retrivedObjects.Add(obj.Id); } } }