Our Databases doesn't have the capacity to store objects directly right? So whenever the system tries to store an object into a table. I automatically want the sytem to store the Object's ID instead into the table. I also want the Inversion of the same task to be done. As I have the Object itself as the property in my class files. Hope you understand right now... Can be Done? It would be better if the above process is done automatically for all class files instead of coding it again and again for different class files...
using System.ComponentModel.DataAnnotations.Schema;
namespace M_VM_V
{
public class Customer
{
private readonly MyDbContext _context;
public Customer() { }
public Customer(MyDbContext context)
{
_context = context;
}
private int _id;
private string _name;
private string _name_tamil;
private string _city;
[NotMapped]
private Customer_Shipping _Shipping;
public int ID
{
get
{
return _id;
}
}
public string Name
{
get
{
return _name;
}
set
{
_name = value;
}
}
public string Name_tamil
{
get
{
return _name_tamil;
}
set
{
_name_tamil = value;
}
}
public string? City
{
get
{
return _city;
}
set
{
_city = value;
}
}
public Decimal Shipping
{
get
{
return _context.Shipping
.Where(cs => cs.Customer.ID == ID)
.OrderByDescending(cs => cs.Moment)
.Select(cs => cs.ShippingAmount)
.FirstOrDefault();
}
set
{
_Shipping.Customer = this;
_Shipping.Moment = DateTime.Now;
_Shipping.ShippingAmount = value;
}
}
}
}namespace M_VM_V
{
public class Customer_Shipping
{
private int _id;
private Customer _customer;
private DateTime _moment;
private Decimal _shipping_Amount;
public int ID
{
get
{
return _id;
}
}
public Customer Customer
{
get
{
return _customer;
}
set
{
}
}
public DateTime Moment
{
get
{
return _moment;
}
set
{
_moment = value;
}
}
public Decimal ShippingAmount
{
get
{
return _shipping_Amount;
}
set
{
_shipping_Amount = value;
}
}
}
}
