//Store
public IFeedback Insert(String contact, String name, String body)
{
var id = UntilDovesCryScalar<long>(CommandType.Text
, String.Format("INSERT INTO dbo.Feedback({0}) VALUES(@Contact, @Name, @Body) "
+ "SELECT SCOPE_IDENTITY()", feedbackInsertList)
, Utility.Parameter("@Contact", contact, true, 255)
, Utility.Parameter("@Name", name, true, 100)
, Utility.Parameter("@Body", body, true, 2000));
var thing = new Data.DO.Feedback
{
ID = id,
Contact = contact,
Name = name,
Body = body,
Created = DateTime.UtcNow
};
return thing;
}
private static IFeedback GetFromReader(ref int columnIndex, IDataReader reader)
{
var id = reader.ColumnValue(columnIndex++, default(long));
var contact = reader.ColumnValue(columnIndex++, String.Empty);
var name = reader.ColumnValue(columnIndex++, String.Empty);
var body = reader.ColumnValue(columnIndex++, String.Empty);
var created = reader.ColumnValue(columnIndex++, DateTime.MaxValue);
var thing = new Data.DO.Feedback
{
ID = id,
Contact = contact,
Name = name,
Body = body,
Created = created
};
return thing;
}
