Hi,
I am busy looking at migrating an old lightswitch application to a radzen blazor application and I have 2 questions I was hoping you could answer.
Firstly I have a Customers table with Id field as key and a Reports table with Id field as key and I then have a CustomerReports table with CustomerId and ReportId as a key which is used to allocate Reports to Customers.
Is it possible to allocate reports to customers the same way that roles are allocated to users. i.e. a drop down box that will list all reports and you can simply tick the items you want. I have tried but have not been able to figure out how to do this..
Secondly is there a way to emulate the 'Choice List' from a lightswitch application. i.e. In lightswitch when you selected a field from the entity and then clicked on 'Choice List' and entered all the possible choices. Then whenever you dropped that field onto a page it would automatically default to a dropdown with the choices that you had entered.
Hey lordrob1, LightSwitch refugee here too!
Looks to me like you're doing a many to many relationship between the customers and reports table. I remember having to research and hand code some queries in LightSwitch for these, because they can get tricky. Hopefully the first couple of posts here will help get you going.
https://forum.radzen.com/search?q=many%20to%20many%20%23blazor
Regarding the other stuff, yes you can get all of the same results, you just have to go about it much differently in Radzen. When you generate the CRUD stuff in Radzen, some of this can be taken care of for you. For example, if you have to tables with a one to many, and have Radzen generate CRUD forms, etc on the one table, it will generate forms that have dropdowns that use the many tables. Datagrid too. I'd recommend you go through the tutorial in the documents section - https://www.radzen.com/documentation/blazor/crm/introduction/ and then do a lot of reading here.
Good luck!
Slosuenos
Thank you so much. I came right with both my items.