How to do update delete using Code first approach and viewmodel in MVC4?

Question

0.00/5 (No votes)

See more:

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.

Posted 5-Jan-16 17:14pm

Member 12087373

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Manoj Kumar Choubey · Answer 1 · 2016-01-05T17:33:00

Solution 1

Simply You need to understand
1. how to create context class and model class
2. How to create and communicate with controller and model
3. how to create view/ partial view.
also need to understand
Data annotation and/or fluent API

You can prefer following links....

Implementing Basic CRUD Functionality with the Entity Framework in ASP.NET MVC Application | The ASP.NET Site[^]
CRUD Operations Using Entity Framework 5.0 Code First Approach in MVC[^]

CRUD operation with Entity Framework 6 Code First approach in MVC 5[^]
C# Corner : Error Display[^]

CRUD Operations Using Entity Framework Code-First Approach[^]

I hope with the help of above link you can we meet your goal.

Posted 5-Jan-16 17:33pm

Manoj Kumar Choubey

Comments

Member 12087373 5-Jan-16 23:37pm

ok manoj let i have a check

Member 12087373 5-Jan-16 23:42pm

Manoj mostly many article is like for single tables. but i have 13 tables. so only i got confusion

Dave Kreskowiak 6-Jan-16 0:07am

You can only Update or Delete records in a single table at a time. There's really no difference between 1 table and 13 tables.

Member 12087373 6-Jan-16 0:13am

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

Dave Kreskowiak 6-Jan-16 0:21am

Come on. You could have found that quite easily just by Googling for "entity framework delete record". It's been documented hundreds of thousands of times.

Google results[^]

Member 12087373 6-Jan-16 0:15am

These 13 tabes is for single view

Dave Kreskowiak 6-Jan-16 0:21am

So what? You don't delete records from a view.

Member 12087373 6-Jan-16 0:26am

i am using existing DB so i need both update and delete process

Dave Kreskowiak 6-Jan-16 9:52am

And? What you REALLY need is to learn the basics of Entity Framework. You get that information from a book on Entity Framework, not from a couple of forum posts. There's just way too much information to convey in a forum environment.

Manoj Kumar Choubey 6-Jan-16 0:24am

I think you need to learn the basic of entity frame-work first.

Member 12087373 6-Jan-16 0:29am

yes before i used linq i didnt use EF so only i struggling for this small concepts

Manoj Kumar Choubey 6-Jan-16 0:34am

You are having 13 tables in the db so you need to create multiple classes for the same please check following link
http://weblogs.asp.net/manavi/inheritance-mapping-strategies-with-entity-framework-code-first-ctp5-part-1-table-per-hierarchy-tph

Manoj Kumar Choubey 6-Jan-16 1:08am

If you found the solution then please accept my answer

How to do update delete using Code first approach and viewmodel in MVC4?

1 solution

Solution 1

Add your solution here

Preview 0

How to do update delete using Code first approach and viewmodel in MVC4?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us