Hi,
I have a relatively small windows forms order processing application.
The Domain model consist of 4 main Entities
Customer
Product
Order
OrderDetail
For reporting purposes I have created a class OrderInfo which is kinda
flat record based on View
Its something like this:
[code]
[ActiveRecord("OrderInfo")]
public class OrderInfo : ActiveRecordBase<OrderInfo>
{
private int id;
// OrderDetail
[PrimaryKey(PrimaryKeyType.Identity,
Column = "OrderDetailId",
Access = PropertyAccess.NosetterCamelcase)]
public int Id
{
get { return id; }
}
[Property]
public virtual int Quantity { get; set; }
// Order
[Property]
public DateTime OrderDate { get; set; }
[Property]
public int OrderId { get; set; }
// Customer
[Property]
public int CustomerId { get; set; }
[Property]
public string CustomerName { get; set; }
// Product
[Property]
public int ProductId { get; set; }
[Property]
public String SKU { get; set; }
[Property]
public string ProductName { get; set; }
.......
}
[/code]
As i said this class is mapped to a View so this is currently working
with no problems
But I want to change my Database to MS Sql Compact which doesn't
support views
Is it possible to map the class to multiple joined tables? I was
trying to use JoinedBase but it seems like it works only with
inheritance.
Any advice is greatly appreciated
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
