public void Insert()
{
string command = @"INSERT INTO " + _activeRecordMap.TableName
+ "(" + SqlBuilderServices.BuildSqlColumnList(_activeRecordMap.ColumnList(false), _activeRecordMap.TableName, SqlBuilderServices.ColumnListType.List) + ")"
+ " VALUES(" + SqlBuilderServices.BuildSqlColumnList(_activeRecordMap.ColumnList(false), _activeRecordMap.TableName, SqlBuilderServices.ColumnListType.ParameterizedList) + ")";
SqlParameter[] parameters = new SqlParameter[_activeRecordMap.ColumnMappings.Count];
//Set Column Parameters
int parameterIndex = 0;
foreach (ColumnMap columnMap in _activeRecordMap.ColumnMappings.Values)
{
SqlParameter parameter = new SqlParameter(columnMap.ColumnName
, SqlBuilderServices.GetDBTypeFromSystemType(columnMap.Property.PropertyType)
, columnMap.Property.GetValue(this, null));
if (parameter.Type == DbType.DateTime && (DateTime)parameter.Value == DateTime.MinValue)
{
parameter.Value = DateTime.Parse("1/1/1900");
}
parameters[parameterIndex] = parameter;
parameterIndex++;
}
//Execute Insert Command
_activeRecordSession.DatabaseServices.ExecuteNonQuery(command, parameters);
//Retrive Primary Key
string query = @"SELECT MAX(" + _activeRecordMap.PrimaryKeyColumnName + ")"
+ " FROM " + _activeRecordMap.TableName
+ " WHERE " + SqlBuilderServices.BuildSqlColumnList(_activeRecordMap.ColumnList(false), _activeRecordMap.TableName, SqlBuilderServices.ColumnListType.WhereParameterizedList);
_activeRecordMap.PrimaryKeyColumnMap.Property.SetValue(this, _activeRecordSession.DatabaseServices.ExecuteScalar(query, parameters), null);
}
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 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));
}
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);
}
