public void Static()
{
var employees = Fluently.Load <List <Employee> >()
.With <EmployeeMap>()
.From <uspGetManagerEmployees>(i => i.ManagerID = 16, x => x.Execute());
Assert.IsNotNull(employees);
Assert.AreEqual(12, employees.Count);
}
public void StaticLoop()
{
for (int index = 0; index < ITERATIONS; index++)
{
var employees = Fluently.Load <List <Employee> >()
.With <EmployeeMap>()
.From <uspGetManagerEmployees>(i => i.ManagerID = 16, x => x.Execute());
Assert.IsNotNull(employees);
Assert.AreEqual(12, employees.Count);
}
}
public User GetUser(Guid userId)
{
//populate basic details:
User user = Fluently.Load <User>().With <UserMap>()
.From <GetUser>(i => i.UserId = userId,
x => x.Execute());
//add accounts:
user.Accounts = Fluently.Load <List <Account> >().With <AccountMap>()
.From <GetUserAccounts>(i => i.UserId = userId,
x => x.Execute());
return(user);
}
public void Dynamic()
{
dynamic getUser = new DynamicSqlStoredProcedure("uspGetManagerEmployees", Database.AdventureWorks);
getUser.ManagerID = 16;
var employees = Fluently.Load <List <Employee> >()
.With <EmployeeMap>()
.From(getUser);
Assert.IsNotNull(employees);
Assert.AreEqual(12, employees.Count);
Assert.AreEqual(0, getUser.RETURN_VALUE);
}