C#•3y ago

Not sure how to set up the model or entity for my code

https://github.com/blueboy90780/Coffee-POS-System/tree/master-remote/CoffeeShop%20POS%20Project%20with%20EF%20Core I'm trying to create a database that represents the coffee menu shown below. The problem with this is that they're not all consistent. Some items have 3 different sizes and 3 different corresponding price, while others have no sizes and and with only one price. I'm not sure how I can reflect such dynamic change in my database model/entity/properties. Could you guys evaluate my EFCore solution in the repo above and give feedback on how I can change it such that it reflects this weird inconsistency?

GitHub

Coffee-POS-System/CoffeeShop POS Project with EF Core at master-rem...

A small practice project to consolidate all learning materials in "C# 10 Fundamentals" PluralSight course so far - Coffee-POS-System/CoffeeShop POS Project with EF Core at master-...

4 Replies

Kouhai•3y ago

[Table("Products")]
internal class Product
{
    public int ProductId { get; set; }

    [MaxLength(100)] public string VNname { get; set; }

    [MaxLength(100)] [Unicode(false)] public string ENname { get; set; }

    public bool Recommended { get; set; }
    public Size? ProductSize { get; set; }
    public List<ProductVariants> Variants { get; set; }
}

[Table("Products")]
internal class Product
{
    public int ProductId { get; set; }

    [MaxLength(100)] public string VNname { get; set; }

    [MaxLength(100)] [Unicode(false)] public string ENname { get; set; }

    public bool Recommended { get; set; }
    public Size? ProductSize { get; set; }
    public List<ProductVariants> Variants { get; set; }
}

[Table("ProductVariants")]
internal class ProductVariants
{
    public int Id { get; set; }
    public Product Product { get; set; }
    [Required] public int Price { get; set; }
    public Size? Size{ get; set; }
    public float? Volume { get; set; }
}

[Table("ProductVariants")]
internal class ProductVariants
{
    public int Id { get; set; }
    public Product Product { get; set; }
    [Required] public int Price { get; set; }
    public Size? Size{ get; set; }
    public float? Volume { get; set; }
}

You can remodel it to include a variants table which would hold the different sizes/prices

Bobby BobOP•3y ago

@KouhaiThank you so much for this! That was such an incredibly simple, yet good solution why didn't I ever think of thbat o-0 😮

Kouhai•3y ago

Np, the more you code the easier it'll be to architecture and design your apps 😄

Bobby BobOP•3y ago

Yeah I'm slowly getting an intuitive understanding of it, ty so much 😄

Gaming

Programming

Not sure how to set up the model or entity for my code

Did you find this page helpful?