Adding a list property to another table

[xQxCPMxQx]

Adding a list property to another table

[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!