private static SqlDataRecord buildRecord(SqlMetaData[] metadata,EventLogEntry entry)
{
SqlDataRecord record = new SqlDataRecord(metadata);
record.SetSqlInt32(0, entry.Index);
record.SetSqlInt64(1, entry.InstanceId);
record.SetSqlDateTime(2, entry.TimeWritten);
record.SetSqlString(3, entry.MachineName);
record.SetSqlString(4, entry.Source);
record.SetSqlString(5, entry.UserName);
record.SetSqlString(6, entry.Message);
return record;
}
private static SqlDataRecord CreateStringIdRecord(string id)
{
var record = new SqlDataRecord(new SqlMetaData("Id", SqlDbType.NVarChar, 16));
record.SetSqlString(0, id);
return record;
}
public void AddSurveyTokensMultiple(int surveyId, DateTime creationDate, IEnumerable<string> tokens)
{
SqlMetaData[] tab = { new SqlMetaData("value", SqlDbType.VarChar, 40) };
List<SqlDataRecord> tokenList =
tokens.Select(x => { var y = new SqlDataRecord(tab); y.SetSqlString(0, x); return y; }).ToList<SqlDataRecord>();
SqlParameter p = new SqlParameter("@tblTokenList", SqlDbType.Structured);
p.Direction = ParameterDirection.Input;
p.TypeName = "dbo.VarcharTableType";
p.Value = tokenList;
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(DbConnection.NewDbConnectionString))
{
conn.Open();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "vts_spSurveyTokenAddMultiple";
cmd.Parameters.Add(p);
cmd.Parameters.Add(new SqlParameter("@SurveyID", surveyId));
cmd.Parameters.Add(new SqlParameter("@CreationDate", creationDate));
cmd.ExecuteNonQuery();
}
// SqlHelper.ExecuteNonQuery(SqlHelper.DbConnectionString, "vts_spSurveyTokenAddMultiple", pars);
}
public void Should_be_able_to_map_from_a_data_record()
{
var record = new SqlDataRecord(new[] { new SqlMetaData("column-1", SqlDbType.VarChar, 65) });
record.SetSqlString(0, new SqlString(null));
var column1 = new MappedColumn<string>("column-1", DbType.AnsiString, 65);
var column2 = new MappedColumn<string>("column-2", DbType.AnsiString, 65);
Assert.AreEqual(default(string), column1.MapFrom(record));
Assert.AreEqual(default(string), column2.MapFrom(record));
record.SetSqlString(0, new SqlString("value-1"));
Assert.AreEqual("value-1", column1.MapFrom(record));
Assert.AreEqual(default(string), column2.MapFrom(record));
}
private static void SendCommandStatus(SqlPipe pipe, SqlInt32 status, SqlString substatus)
{
SqlDataRecord rec = new SqlDataRecord(
new SqlMetaData("Status", SqlDbType.Int)
, new SqlMetaData("SubStatus", SqlDbType.NVarChar, 150)
);
SqlContext.Pipe.SendResultsStart(rec);
rec.SetSqlInt32(0, status);
rec.SetSqlString(1, substatus);
pipe.SendResultsRow(rec);
pipe.SendResultsEnd();
}