//Store
public ISynonym Insert(String source, String result)
{
var id = UntilDovesCryScalar<long>(CommandType.Text
, String.Format("INSERT INTO dbo.Synonym({0}) VALUES(@Source, @Result) "
+ "SELECT SCOPE_IDENTITY()", feedbackInsertList)
, Utility.Parameter("@Source", source, true, 2000)
, Utility.Parameter("@Result", result, true, 2000));
var thing = new Data.DO.Synonym
{
ID = id,
Source = source,
Result = result,
Created = DateTime.UtcNow
};
return thing;
}
private static ISynonym GetFromReader(ref int columnIndex, IDataReader reader)
{
var id = reader.ColumnValue(columnIndex++, default(long));
var source = reader.ColumnValue(columnIndex++, String.Empty);
var result = reader.ColumnValue(columnIndex++, String.Empty);
var created = reader.ColumnValue(columnIndex++, DateTime.MaxValue);
var thing = new Data.DO.Synonym
{
ID = id,
Source = source,
Result = result,
Created = created
};
return thing;
}
