[dba-Tech] asp.net vb EF issues

Thanks Jim
I did set up the Analysis Services bit on SQL Server so there was such an account but no luck there.

Right now I've got the gridview to show (this is still only AdventureWorks, mind):
I edited the connection string in web.config, replaced each res://*/ with res://AdventureWorks/
I edited (the xml view of) Model1.edmx, changed
<EntityContainer Name="Entities" p1:LazyLoadingEnabled="true">
at the beginning of csdl to
<EntityContainer Name="AdventureWorks2008R2Entities" p1:LazyLoadingEnabled="true">
and
<EntityContainerMapping StorageEntityContainer="AdventureWorks2008R2ModelStoreContainer" CdmEntityContainer="Entities">
at the beginning of the mapping section to
<EntityContainerMapping StorageEntityContainer="AdventureWorks2008R2ModelStoreContainer" CdmEntityContainer="AdventureWorks2008R2Entities">

That moved the error on to a little thing about needing a sort by entry in the datasource so I've stuck a field name in that property and suddenly F5 gives me a list of records in the browser.

Gas is starting to seep through, cooking comes later.

regards
Mike


-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: 21 May 2013 19:16
To: 'Discussion of Hardware and Software issues'
Subject: Re: [dba-Tech] asp.net vb EF issues

Hi Mike:

"...Press F5, error shows up in the browser:- Schema specified is not valid.
Errors:
App_Code.Model1.csdl(3,4) : error 0019: The EntityContainer name must be unique. An EntityContainer with the name 'AdventureWorks2008R2Entities' is already defined.
App_Code.Model1.csdl(6,4) : error 0019: Each type name in a schema must be unique. Type name 'AdventureWorks2008R2Model.Product' was already defined...."

Ran across that problem a few years ago and as I remember it was something to do with a settings in the configuration file and how I installed the Adventure Works demo. It seemed easy at the time but... If I remember, I will post here.

http://msdn.microsoft.com/en-us/library/fc475b25-cbb2-408a-901f-9299299538c5

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Tope Mike
Sent: Tuesday, May 21, 2013 9:57 AM
To: 'dba-tech at databaseadvisors.com'
Subject: [dba-Tech] asp.net vb EF issues

Hi all
Quite different from my usual practice of using databaseadvisors as a time machine, catching up on posts months after the event, I've subscribed from work to ask for your help on a live issue. I'm in London so my afternoon will be morning for most of you.

The subject concerns a recent install of Visual Studio Express 2012 for Web now with update 2, with a  Nuget update to the Entity Framework to 5.0.0.
Basically, I'm not having any luck with it. It seems to be creating the model in duplicate, then complaining of conflicts and refusing to go any further.
******************************************************************************************
CONFIDENTIALITY NOTICE
This e-mail and any attachment are confidential and may be privileged or otherwise protected from disclosure. It is solely intended for the person(s) named above. If you are not the intended recipient, any reading, use, disclosure, copying or distribution of all or parts of this e-mail or associated attachments is strictly prohibited. If you are not an intended recipient, please notify the sender immediately by replying to this message or by telephone and delete this e-mail and any attachments permanently from your system.