protected VLSystemUserView ExecuteAndGetSystemUserView(DbCommand cmd)
{
VLSystemUserView _retObject = null;
try
{
cmd.Connection.Open();
using (DbDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows == false)
{
return(null);
}
reader.Read();
_retObject = new VLSystemUserView(reader);
}
}
finally
{
cmd.Connection.Close();
}
return(_retObject);
}
protected Collection <VLSystemUserView> ExecuteAndGetSystemUserViews(DbCommand cmd)
{
var collection = new Collection <VLSystemUserView>();
try
{
cmd.Connection.Open();
using (DbDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
var _object = new VLSystemUserView(reader);
collection.Add(_object);
}
}
}
finally
{
cmd.Connection.Close();
}
return(collection);
}