The specified type member '' is not supported in LINQ to Entities.

Getting issue with entity framework for newly added column into database table.

The specified type member '' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

How to call Stored Procedure in Entity Framework

 Entity  frame work providing the option of adding, updating or deleting the records. It is also giving the way of calling the store procedure in entity Framework to Insert, Update and Delete the options.

Entity framework will create User defined function for store procedures.

 Let’s see how we can add call the store procedure in entity frame work.

1.              Creation of store procedure in database.

Entity framework code first example

A simple example of code first approach in entity frame work.

1.       Take the reference of entity frame work from Nugget Package and install it.

Top 30 Entity Framework Interview Question

1.       What is Entity Framework?

Entity Framework is based on Object Relation model (ORM) framework developed by Microsoft.

It will automate the Why of interaction between database and your code. It makes your application as rapid develop by overriding for creating of framework for all your ADO.net.

It make easier to access Data base using linq query.

You can access the tables and storeprocedure detail in c# code and perform the crud operation very easily.

2.       What its advantage?

Advantage of using entity framework is to generate the automated code to interact with data base. Its make your application in fast pace of development.

web api with entity framework example in MVC

You can give the answer of below question after complete this exercise.

• Webapi example in mvc 5 
• How to add Web API to an existing ASP.NET MVC (5) 
• Differnce in WEBApi Controller and MVC Controller
• List of Verb in WebAPI
• How to place Routing for WebAPI
• How to check the WEBApi Get
• How to use Advance Rest Client.
• How to  Check WEBApi Post
• How to  Check WEBApi Put
• How to  Check WEBApi Delete
• Convert object to json in MVC.
• How to Use WebClient to call WebApi
• How to call WebApi through Webpage
• call web api from mvc controller
• How to declare local variable in MVc in Loop
• How to use @Html.BegainForm
• How to create Partial view.
• How to call partial View in MVC
• How to call web api post Action WebClient
• How to call web api Put action WebClient
• How to call web api Delete in WebClient.
• How to delete record in web api using WebClient
• Edit operation in mvc 4 with model pop

Demonstrating a simple application using MVC, WebApi and EntityFramework;
Web api example in mvc 5

entity framework insert update delete

As in previous article explained that how we can create the entity frame work classes and how we can use it. 

Refer below link for the same;

http://www.getmscode.com/2015/04/entity-framework-in-aspnet.html

Now in This Session will explain you how to perform the insert update delete operation in entity framework.

Suppose you have the table like below

Entity framework in asp.net

Microsoft make our life easier to provide the Entity frame work and release us to use the traditional way to use the database connectivity. It provides an O/RM framework called "Entity Framework" to automate database.

By Entity Framework in Asp.net, developer’s can queries using LINQ, then retrieve, Insert, Update and manipulate data as strongly typed objects. 

Entity Framework can be useful on any type of architecture opted by you either is code first approach or data driven approach.

 In Code first approach either you can have all the code views or by this you want to create the data base.

In Data Driven approach you have database ready and by which you want to create the classes that will interact with the database.

I am going to demonstrate the Data driven approach. It’s really good for beginners for starting the entity framework.

11 Steps to create Entity Framework and work with it.

1.       Suppose you have data base with below given table.