![]() In the web page, I need to put, for each CategoryName, a list of distinct CategoryMake, and for each CategoryName + CategoryMake, the list of CategoryType, using mat-autocomplete fields. I tried to extract the different values from the original (dirty) table, in order to create a lookup table.ĭue to I have different fields with the same data type, I figured out to develop a vertical table as follows: Id CategoryName CategoryMake CategoryType Some of the string fields need to be normalized, reading data from a "clean" list. ![]() Initially, all the fields were strings or numbers, without any kind of check of the correctness of the values (I have inherited dirty data from an old database). I hope to post a clear issue: I have already implemented classes, API and SPA page to show stock technical properties. I'm new to this forum, and I have only few experience using Entity Framework. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |