How to insert data in multiple tables using single query?

Question

I want to insert data into multiple tables at a time using single query with entity framework in MVC. I am using WCF service to perform the INSERT operation. Thanks in advance.

S P · Answer

I am not using store procedure. I am adding data with the code db.table.Add(); But it is not working for me.

Tapan Patel · Answer

Not sure about how far you want to go but you can start with either aggregating inserts and combine them in Stored Procedure or triggers on table which will insert data in another table ( this really depends on what data you want to store).