/// <summary>
/// Generates the populate method.
/// </summary>
/// <param name="table">The table.</param>
private void GeneratePopulateMethod(DatabaseTable table)
{
_content = _content.Replace("<%[LowerCaseTableName]%>", table.Name.ToLower());
StringBuilder builder = new StringBuilder();
for (int index = 0; index < table.Columns.Count; index++)
{
bool isLastItem = (index == table.Columns.Count - 1);
const string populate = "\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t{0} = {1}{2}";
builder.Append(string.Format(populate, table.Columns[index].Name, SqlTypeConversion.FindConvertToMethodsBySqlType(table.Columns[index].SqlColumnType, table.Columns[index].Name), (isLastItem ? string.Empty : ",")));
}
_content = _content.Replace("<%[PopulateProperities]%>", builder.ToString());
}
private void GetItem(DatabaseTable table)
{
StringBuilder builder = new StringBuilder();
foreach (DatabaseColumn column in table.Columns)
{
builder.AppendLine(string.Format("\t\t\t{0}.{1} = {2};", table.Name.ToLower(), column.Name, SqlTypeConversion.FindConvertToMethodsBySqlType(column.SqlColumnType, "reader[\"" + column.Name + "\"]")));
}
_content = _content.Replace("<%[GetItemObjectPopulation]%>", builder.ToString());
}
