Skip to Content
Former Member
Aug 17, 2014 at 05:23 PM

Manage multi-table insert using OData Service


Hi all,

I would like to understand how can I manage multi-table inserts using odata service.

Problem :

For example I have two tables :

1. Customer (Customer_ID as primary key)

2. Orders (Order_ID as primary key and Customer_ID as foreign key)

Customer Table has one to many relationship Order Table.

I would like to create OData Service where I can manage insert/update/delete transactions.

I have little idea that I can use "Associations" for joining to tables but I have not sure about following points:

1. Is "Associations" support CRUD operations?

2. How can I manage auto-generated primary key creations for Customer_ID and Order_ID?

Please advice.