2 requet with one Button

bensassi ch

Hello ,
I just devlopper a quiz type application online with C # and entity framework
I have a form that contains two fields (question and Reponse)
the question can have one or more response and checkbox type fields to check if the answer true or false.
now I want to make my request with entity framework to record the questions in the question table
and answers in a table and answer the Recuper The ID_question to be a foreign key in the answer table
questions: how do I do to make the same record the question in the question and the answers table and id_question in the response tables ???

poure record in the table question is made
just how I change my Requet to retrieve the id_question and back it up with the answers in Table answer
Attention !! with a single button send two Requets

Requet here is my question in my controller

Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Yes,you will need a Stored procedure and in Stored procedure first you will insert the record in first table(i.e. Question Table) then you can get the ID for the Question from first table(i.e. question table) and then you can insert the answer record with Question id to second table(i.e. Answer Table).
You can both operation in a single stored procedure.
+1
Syed Shanu11y ago
You can create a Stored procedure and in SP first you can insert the record to Question Table .You can get the ID for the Question table and then you can insert the answer record with Question id to Answer table. In one SP you can Insert to both the table.
+1