This question is locked. New answers and comments are not allowed.
I port MSSQL "Music Store" database to PostgreSQL database for testing MVC2. Now for query database I use Open Acess ORM. For selected code :
I got this error :
Error 1 'System.Linq.IQueryable<MyMVC.Genre>' does not contain a definition for 'Include' and no extension method 'Include' accepting a first argument of type 'System.Linq.IQueryable<MyMVC.Genre>' could be found (are you missing a using directive or an assembly reference?) C:\Users\Michael\Documents\Visual Studio 2010\Projects\MyMVC\MyMVC\Controllers\StoreController.cs 37 45 MyMVC
Any help?
Michael
p.s. If anyone ned Create script for PostgreSQL Music Store, make replay here.
namespace
MyMVC.Controllers
{
public
class
StoreController : Controller
{
MvcMusicStoreModel storeDB =
new
MvcMusicStoreModel();
//
// GET: /Store/Browse
public
ActionResult Browse(
string
genre)
{
// Retrive Genre and its Associated Albums from database
// ---> HERE IS ERROR!!!
var genreModel = storeDB.Genres.Include(
"Albums"
)
.Single(g => g.Name == genre);
// <--- HERE IS ERROR!!!
var viewModel =
new
StoreBrowseViewModel
{
Genre = genreModel,
Albums = genreModel.Albums.ToLIst()
};
return
View(viewModel);
}
I got this error :
Error 1 'System.Linq.IQueryable<MyMVC.Genre>' does not contain a definition for 'Include' and no extension method 'Include' accepting a first argument of type 'System.Linq.IQueryable<MyMVC.Genre>' could be found (are you missing a using directive or an assembly reference?) C:\Users\Michael\Documents\Visual Studio 2010\Projects\MyMVC\MyMVC\Controllers\StoreController.cs 37 45 MyMVC
Any help?
Michael
p.s. If anyone ned Create script for PostgreSQL Music Store, make replay here.