public void Can_select_from_Custom_stored_procedure()
{
using (var db = OpenDbConnection())
{
db.DeleteAll<Address>();
db.DeleteAll<Order>();
db.DeleteAll<ProUser>();
var user = new ProUser
{
Id = "A",
Password = "******",
UserType = 1,
};
db.Insert(user);
var order = new Order
{
ProUserId = user.Id,
Details = "Details",
ItemId = 1,
};
db.Insert(order);
var address = new Address
{
ProUserId = user.Id,
StreetName = "1 Street",
ZipCode = 90210
};
db.Insert(address);
var rows = db.SqlList<DomainUserDto>(
"EXEC TestJoinSupportForORMLite @Id", new { user.Id });
rows.PrintDump();
}
}
public void Can_select_from_Custom_stored_procedure()
{
using (var db = OpenDbConnection())
{
db.DeleteAll <Address>();
db.DeleteAll <Order>();
db.DeleteAll <ProUser>();
var user = new ProUser
{
Id = "A",
Password = "******",
UserType = 1,
};
db.Insert(user);
var order = new Order
{
ProUserId = user.Id,
Details = "Details",
ItemId = 1,
};
db.Insert(order);
var address = new Address
{
ProUserId = user.Id,
StreetName = "1 Street",
ZipCode = 90210
};
db.Insert(address);
var rows = db.SqlList <DomainUserDto>(
"EXEC TestJoinSupportForORMLite @Id", new { user.Id });
rows.PrintDump();
}
}
