How to do update delete index using Code first approach and

Question

Hi i have one view and it contain 22 fields. My DB is fully normalized. I have 13 tables to save those 22 fields. I used Code First approach and ViewModel for insertion . I did same as like which is mentioned in the below link for insertion process

http://www.codeproject.com/Tips/651495/Inserting-Data-into-Multiple-Tables-using-Code-Fir

Now insertion is working fine now i want to do UPDATE, DELETE, INDEX process using codefirstapproach and ViewModel in MVC4 i donno how to do this . For Index i write Inner Join query . But for Update and Delete Process? i donno how to retreive data from multiple able for update and delete process. Please any one give me solution with one example.

Advance Thanks.

Sneha Dhandapani · Answer

Pramod Most of the article is for single table not for multiple table that is creating each table as each view . but i created multiple table in single view. for that i need update and delete process

Pramod Thakur · Answer

Hi sneha I think this link can help you. http://www.asp.net/mvc/overview/older-versions/getting-started-with-ef-5-using-mvc-4/updating-related-data-with-the-entity-framework-in-an-asp-net-mvc-application

Sneha Dhandapani · Answer

how to send any mail id

Ravi Patel · Answer

yes send the code.

Sneha Dhandapani · Answer

Ravi I need to update all fields except that Main ID shall i send my code

Sneha Dhandapani · Answer

how to do that . eg I have CustomerName Age Address Street location City state Country Contact no email fields in my view. CustomerName and Age is saved in Customer table. Address City State Street  Location is saved in AddressTable. Contact No Email are save in contact table. Now i want to update Address and Email and age of that particular customer means how to do this using code first approach

Sneha Dhandapani · Answer

Yes Yes I have 13 tables to insert that 22 fields . Now i want to know how to fetch the data from that Multiple table and do update and Delete process

Ravi Patel · Answer

Hi you want to update multiple table at time ? what are the field you want to update and what are data passing from view ?