public static IEnumerable <User> GetUsers(this ConnectionManager source)
{
var users = new List <User>();
var cmd = new AdhocQuery("SELECT Id, Name FROM Users");
var ds = new DataSet();
source.FillDataSet(cmd, ds);
if (ds.TableCount() > 0)
{
foreach (var row in ds.Tables[0].AsEnumerable())
{
users.Add(new User(row.GetInt32ValueOrDefault("Id"))
{
Name = row.GetStringValueOrDefault("Name")
});
}
;
}
;
return(users);
}
public void Ctor_AdhocQuery_CommandTextValid()
{
//Act
var actual = new AdhocQuery("SELECT * FROM Tables");
//Assert
actual.CommandText.Should().Be("SELECT * FROM Tables");
actual.CommandType.Should().Be(CommandType.Text);
}
public static IEnumerable <Role> GetRoles(this ConnectionManager source)
{
var cmd = new AdhocQuery("SELECT Id, Name FROM Roles");
return(source.ExecuteQueryWithResults(cmd, r =>
new Role(r.GetInt32OrDefault("Id"))
{
Name = r.GetStringOrDefault("Name")
}
));
}
public static User GetUser(this ConnectionManager source, int id)
{
var cmd = new AdhocQuery("SELECT Id, Name FROM Users where Id = @id").WithParameters(
InputParameter.Named("id").WithValue(id)
);
return(source.ExecuteQueryWithResult(cmd,
r => new User(r.GetInt32OrDefault("Id"))
{
Name = r.GetStringOrDefault("Name")
}));
}
public static void AdhocQuery(AdhocQuery query, string id)
{
Assert.AreEqual(id ?? "", query.Id ?? "");
}
