/// <summary>
/// Finds a TestNoUpdate entity using it's primary key.
/// </summary>
/// <returns>A TestNoUpdateData object.</returns>
/// <exception cref="Spring2.Core.DAO.FinderException">Thrown when no entity exists witht he specified primary key..</exception>
public static TestNoUpdateData Load()
{
WhereClause w = new WhereClause();
SqlDataReader dataReader = GetListReader(CONNECTION_STRING_KEY, VIEW, w, null);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for TestNoUpdate.");
}
TestNoUpdateData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
/// <summary>
/// Returns an object which matches the values for the fields specified.
/// </summary>
/// <param name="sqlstringcolumn">A field value to be matched.</param>
/// <param name="sqlintcolumn">A field value to be matched.</param>
/// <returns>The object found.</returns>
/// <exception cref="Spring2.Core.DAO.FinderException">Thrown when no rows are found.</exception>
public static TestNoUpdateData FindByPK(StringType stringColumn, IdType int32Column)
{
OrderByClause sort = new OrderByClause("sqlstringcolumn, sqlintcolumn");
WhereClause filter = new WhereClause();
filter.And("sqlstringcolumn", stringColumn.DBValue);
filter.And("sqlintcolumn", int32Column.DBValue);
SqlDataReader dataReader = GetListReader(CONNECTION_STRING_KEY, VIEW, filter, sort);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("TestNoUpdateData.FindByPK found no rows.");
}
TestNoUpdateData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
/// <summary>
/// Builds a data object from the current row in a data reader..
/// </summary>
/// <param name="dataReader">Container for database row.</param>
/// <returns>Data object built from current row.</returns>
private static TestNoUpdateData GetDataObjectFromReader(SqlDataReader dataReader)
{
TestNoUpdateData data = new TestNoUpdateData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlstringcolumn")))
{
data.StringColumn = StringType.UNSET;
}
else
{
data.StringColumn = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("sqlstringcolumn")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("sqlintcolumn")))
{
data.Int32Column = IdType.UNSET;
}
else
{
data.Int32Column = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("sqlintcolumn")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("EmailFormat")))
{
data.EmailFormat = FormatType.UNSET;
}
else
{
data.EmailFormat = FormatType.GetInstance(dataReader.GetString(dataReader.GetOrdinal("EmailFormat")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("addr1")))
{
data.Address.Address1 = StringType.UNSET;
}
else
{
data.Address.Address1 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr1")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("addr2")))
{
data.Address.Address2 = StringType.UNSET;
}
else
{
data.Address.Address2 = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("addr2")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("city")))
{
data.Address.City = StringType.UNSET;
}
else
{
data.Address.City = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("city")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("state")))
{
data.Address.State = StringType.UNSET;
}
else
{
data.Address.State = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("state")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("zip")))
{
data.Address.PostalCode = StringType.UNSET;
}
else
{
data.Address.PostalCode = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("zip")));
}
return(data);
}
