public GumboBag GetBagFor(Guid id, Guid version)
{
var result = new GumboBag();
using (IDbConnection conn = new SqlConnection(_settings.ConnectionString))
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = GumboTSql.ReadProperties;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@target_id", id));
cmd.Parameters.Add(new SqlParameter("@target_version", version));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var prop = new GumboProperty();
prop.Version = reader.GetGuid(0);
prop.Name = reader.GetString(1);
prop.Value = reader[2];
result.Add(prop);
}
}
}
return(result);
}
public GumboBag GetBagFor(Guid id, Guid version)
{
var result = new GumboBag();
using (IDbConnection conn = new SqlConnection(_settings.ConnectionString))
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = GumboTSql.ReadProperties;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter("@target_id", id));
cmd.Parameters.Add(new SqlParameter("@target_version", version));
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var prop = new GumboProperty();
prop.Version = reader.GetGuid(0);
prop.Name = reader.GetString(1);
prop.Value = reader[2];
result.Add(prop);
}
}
}
return result;
}
