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