The stored procedure returns an OrderTotal column along with the other standard Order columns. The OrderTotal is calculated on the fly in the stored proc. I've then added my own partial Order class to the SubSonic generated class.
public partial class
Order
{
public decimal OrderTotal { get; set; }
}
When using the stored proc and ExecuteTypedList on the Order class only the SubSonic partial Order class members get populated. The OrderTotal member remains empty. But if I define a new class:
public class
OrderExtended
{
public int
OrderID { get; set; }
public string
Address { get; set; }
public string
FullName { get; set; }
public decimal
OrderTotal { get; set; }
}
Everything gets populated using ExecuteTypedList<OrderExtended>. So the question is when using ExecuteTypedList for stored procedures do you need to define a new class from scrath that contains all the members you want or are partial classes supported and I am simply doing something wrong?