Basically I have 3 tables:
Table 1: tblCars (fields: CarId, CarName)
Table 2: tblAppointments (fields: ApptId, ApptStart, ApptEnd...)
Table 3 (links 1 & 2): tblReserve (fields: ApptId, CarId)
An "Appointment" can reserve MANY cars, hence the need for Table 3.
I want a new appointment to allow them to select 1 or more cars then save it. On save it saves the appointment and the necessary info to Table 3.
How do you suggest I handle this? I was thinking that I could use Resource Types, but wasn't sure how to save them to Table 3 etc...
Any thoughts on this?
Table 1: tblCars (fields: CarId, CarName)
Table 2: tblAppointments (fields: ApptId, ApptStart, ApptEnd...)
Table 3 (links 1 & 2): tblReserve (fields: ApptId, CarId)
An "Appointment" can reserve MANY cars, hence the need for Table 3.
I want a new appointment to allow them to select 1 or more cars then save it. On save it saves the appointment and the necessary info to Table 3.
How do you suggest I handle this? I was thinking that I could use Resource Types, but wasn't sure how to save them to Table 3 etc...
Any thoughts on this?
1 Answer, 1 is accepted
0
Hello Robert,
This scenario is supported and we have an online example that demonstrates very similar scenario. As you have noted, this scenario is not supported with the standard data source controls. It requires you to author a custom provider. This is not as easy as using data source controls, but you gain complete freedom about over the database access. Additionally, you can reuse most of the sample provider. You can also use LINQ-to-SQL or any other ORM tool.
Kind regards,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
This scenario is supported and we have an online example that demonstrates very similar scenario. As you have noted, this scenario is not supported with the standard data source controls. It requires you to author a custom provider. This is not as easy as using data source controls, but you gain complete freedom about over the database access. Additionally, you can reuse most of the sample provider. You can also use LINQ-to-SQL or any other ORM tool.
Kind regards,
Tsvetomir Tsonev
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center