1. The type or namespace name 'HttpPostAttribute' could not be found (are you missing a using directive or an assembly reference?)

2. 'MyWebsite.Models.MoviesEntities' does not contain a definition for 'AddToMovies' and no extension method 'AddToMovies' accepting a first argument of type 'MvcApplication4.Models.MoviesEntities' could be found (are you missing a using directive or an assembly reference?)

regard's

Ekky Patria

ASP.Net Developer

Exception details:

Unable to update EntitySet 'Movie' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation.

praveenbattula.blogspot.com/

When you do that,you might have to delete your old connection string in the web.config as well. Otherwise you'll get movies.entities1.

[AcceptVerbs(HttpVerbs.Post)]

in place of [HttpPost]

i have a little problem...when i click create button it does not add the data into the database meaning it said my modelstate is invalid can u help

if (ModelState.IsValid)

{

db.AddToMovies(newMovie);

...

}

How exactly is ModelState.IsValid working? where is db.AddToMovies() function defined?

I keep getting this error

-------------------------------------

Inconsistent accessibility: parameter type 'Movies.Controllers.Movie' is less accessible than method 'Movies.Controllers.MoviesController.Create(Movies.Controllers.Movie)'

----------------------------------

somebody please help

"Unable to update the EntitySet 'Movie' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation."

deciaml(18,2)

There is no SaveChanges method in the class MvcMovie.Designer.cs,

so the ocde fails on this line:

in MoviesController.cs/db.SaveChanges();

This automatically-generated code is calling a function which does not exist(SaveChanges).

Error mesage:

System.Data.UpdateException was unhandled by user code

Message="Unable to update the EntitySet 'Movie' because it has a DefiningQuery and no <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation."

Source="System.Data.Entity"

StackTrace:

at System.Data.SqlClient.SqlGen.DmlSqlGenerator.ExpressionTranslator.Visit(DbScanExpression expression)

at System.Data.Common.CommandTrees.DbScanExpression.Accept(DbExpressionVisitor visitor)

at System.Data.SqlClient.SqlGen.DmlSqlGenerator.GenerateInsertSql(DbInsertCommandTree tree, SqlVersion sqlVersion, List`1& parameters)

at System.Data.SqlClient.SqlGen.SqlGenerator.GenerateSql(DbCommandTree tree, SqlVersion sqlVersion, List`1& parameters, CommandType& commandType)

at System.Data.SqlClient.SqlProviderServices.CreateCommand(DbProviderManifest providerManifest, DbCommandTree commandTree)

at System.Data.SqlClient.SqlProviderServices.CreateCommand(DbCommandTree commandTree)

at System.Data.Mapping.Update.Internal.UpdateTranslator.CreateCommand(DbModificationCommandTree commandTree)

at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.CreateCommand(UpdateTranslator translator, Dictionary`2 identifierValues)

at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)

at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)

at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)

at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)

at System.Data.Objects.ObjectContext.SaveChanges()

at MvcMovie.Controllers.MoviesController.Create(Movie newMovie) in C:\VisStudio_2008_Projects\MvcMovie\MvcMovie\Controllers\MoviesController.cs:line 37

at lambda_method(ExecutionScope , ControllerBase , Object[] )

at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)

at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)

at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)

at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a()

at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)

InnerException:

---

public ActionResult Create(Movie newMovie)

{

if (ModelState.IsValid)

{

db.AddToMovie(newMovie);

db.SaveChanges();

return RedirectToAction("Index");

}

else

{

return View(newMovie);

In Server Explorer Window>DataConnections, Rt. click the table, Movies, and select Table Definition. Make the Id column the Primary Key. (Should have done that eralier in the process, but its OK - I learned something.) Now, in the Solution Explorer, open(db clk) the file called MovieEntities.edmx. This window shows you a gui to mod your connection to the Movie DB table. Rt. Clk on Id column, nad select Update Model from Database. Now your C# app knows that Movie has a Primary key - the Id column. Since it knows there is a PK defined, when you create a form to Create a new movie, you will now have the option show up in the View Content drop-down meny on hte Add View Wizard window. Since you can select this 'Create' option, all the code for creating the form will be auto-magically written for you.

Actually the function is db.AddTo"Tablename"() if your table name is Movies then you can give

db.AddToMovies