/// <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()); }