Adding a list property to another table

[xQxCPMxQx]

I have a model as below:

public class Product
    {
        public int ProductId {get;set;}
        public string ProductName {get;set;}
        public IList<Guid> aList { get; set; }
    }

And the result in the model is like this:
ProductId: 99901
ProductName: Product01
aList

• as222-3e44-2002-2a2s2-2ss4
• as2xg-3e44-2002-2a2s2-2ss4
• wq222-33e2-2022-2a2s2-2ss4

How do I add this model to database like below?

Table Products:
ProductId | ProductName
99901 | Product01

Table ProductListData:
ProductId | ListValue from aList
99901 | wq222-33e2-2022-2a2s2-2ss4
99901 | as222-3e44-2002-2a2s2-2ss4
99901 | as2xg-3e44-2002-2a2s2-2ss4

I solve the problem with different methods, but I cannot change the structure of this model. I have to conform to this structure of the model.

I hope I was able to explain my problem.
Thank you

[JonathanMagnan]

Hello @xQxCPMxQx ,

Is it possible for you to create another class or use an expando object?

For example, having something like this:

public static class MyExtensions
{
	public static List<ExpandoObject> ExpandProducts<T>(this List<Product> products)
	{
		var list = new List<ExpandoObject>();
		
		foreach(var product in products)
		{
			foreach(var a in product.aList)
			{
				// WOULD be better if you could create another class but otherwise, expando could work fine
				var expando = new ExpandoObject();
				expando.ProductId = product.ProductId;
				expando.ListValue = a;
				
				list.Add(expando);
			}
		}
		
		return list;
	}
}

// Map
DapperPlusManager.Entity<ExpandoObject>("productListData").Table("ProductListData");
 
// Insert
connection.BulkInsert(products);
connection.BulkInsert("productListData", products.ExpandProducts());

(code has not been tested so might contains some coding mistake)

Let me know if that solution could work for you.

Best Regards,

Jon

[xQxCPMxQx]

I don't know how much to thank you. It works great!!!
Thank you so much!