Chapter 14: Simple EntitySource Application try-it out

K_Joe · February 10th, 2014, 01:42 PM

Ive tried to refresh the schema to show the appropriate columns in the NewPhotoAlbum details view. However I continue getting the error for unable to find CLR type for 'PlanetWroxModel.PhotoAlbum'

I redid the entity data model numerous times, and still no change, also checked to make sure the appropriate relation between PhotoAlbum and Picture tables where made.

Imar · February 10th, 2014, 05:11 PM

Hi there,

Maybe you made a mistake in the database? Can you post an image of the relevant tables in Design Model in SQL Server Management Studio?

Imar

K_Joe · February 11th, 2014, 10:45 AM

Here is the model layout,

http://s560.photobucket.com/user/Tri...0886f.png.html

Imar · February 11th, 2014, 12:28 PM

Hi there,

You posted a picture of the EF model diagram in Visual Studio, bu I need to see the tables in Design View in SQL Server Management Studio instead. E.g. a screenshot of the screen where you define the columns for the tables.

Cheers,

Imar

K_Joe · February 12th, 2014, 10:35 AM

Is that what your referring to?

CREATE TABLE [dbo].[Picture] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Description] NVARCHAR (300) NOT NULL,
[ToolTip] NVARCHAR (50) NOT NULL,
[ImageUrl] NVARCHAR (100) NOT NULL,
[PhotoAlbumId] INT NOT NULL,
CONSTRAINT [PK_Picture] PRIMARY KEY CLUSTERED ([Id] ASC),
CONSTRAINT [FK_Picture_PhotoAlbum] FOREIGN KEY ([PhotoAlbumId]) REFERENCES [dbo].[PhotoAlbum] ([Id])
);

CREATE TABLE [dbo].[PhotoAlbum] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (100) NOT NULL,
CONSTRAINT [PK_PhotoAlbum] PRIMARY KEY CLUSTERED ([Id] ASC)
);

K_Joe · February 12th, 2014, 01:48 PM

I was able to fix the problem by changing the code generation strategy to default, but when I try to request the page at the end of the try it out, it throws the error of not being able to cast over e.Entity with PhotoAlbum

Imar · February 15th, 2014, 10:44 AM

Are you using VS 2013 and ASP.NET 4.5.1 by any chance? They no longer support the LinqDataSource.

If that's not the case, can you provide detailed error information and your code?

Cheers,

Imar

K_Joe · February 16th, 2014, 05:00 PM

fixed it by redo the steps over again and rebuilding it, using vs2012 by the way and framework 4.5