DevForce Community Forum : Prism Explorer-How to Install NorthwindEF Database http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Prism Explorer-How to Install NorthwindEF Database Tue, 12 May 2026 19:36:30 -700 Tue, 28 Sep 2010 10:05:14 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1614 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Prism Explorer-How to Install NorthwindEF Database : Oops! PrismExplorer no longer... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=8656#8656 Author: WardBell
Subject: 1614
Posted: 28-Sep-2010 at 10:05am

Oops! PrismExplorer no longer uses NorthwindEF ... and we neglected to tell you. Sorry you wasted your time looking.
 
Prism Explorer now uses NorthwindIB, the tutorial database installed with DevForce.
 
We wanted to reduce the number of steps you need to get going ... and installing another database seemed like unnecessary friction. You can also get NorthwindIB independently from our website [reference needed].
 
The action item for us is to update the documentation to reflect that change.
 
I editted the initiating post to reflect this change so that folks don't have to scroll here to learn of the change.


Edited by WardBell - 28-Sep-2010 at 10:17am]]> Tue, 28 Sep 2010 10:05:14 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=8656#8656 Prism Explorer-How to Install NorthwindEF Database : I have searched all over the place... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=8652#8652 Author: tj62
Subject: 1614
Posted: 28-Sep-2010 at 3:58am

I have searched all over the place but not finding the NorthWindEF database usable for the VS2010 version of PrismExplorer. I have the one used for VS2008 version of PrismExplorer, but that one does not seem to work.

Where in heck do I find the NorhtWindEF for PrismExplorer 2010? Am I blind?
]]> Tue, 28 Sep 2010 03:58:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=8652#8652 Prism Explorer-How to Install NorthwindEF Database : Bruce, welcome aboard! Pleased... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6074#6074 Author: WardBell
Subject: 1614
Posted: 12-Jan-2010 at 3:15pm

Bruce, welcome aboard!  Pleased all turned out well.
 
I wish I could talk to everyone directly but just not enough of me to go around :-(
 
Don't know if your whether you are a customer with paid support or using the free version. If the free version, you can post to the forum and we will try to answer your questions in a timely fashion. If you are a customer, you can submit a support request here: http://www.ideablade.com/CustomerSupportRequestForm.aspx
 
Used to write Cobol myself; don't miss it at all.  Cheers, W
 
 
]]> Tue, 12 Jan 2010 15:15:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6074#6074 Prism Explorer-How to Install NorthwindEF Database : Thank you Ward for your suggestions. I... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6071#6071 Author: BruceKu
Subject: 1614
Posted: 12-Jan-2010 at 9:51am

Thank you Ward for your suggestions.
 
I checked connection to DB both ways (Server Explorer and thru Entity Model ) and both worked.
 
Then I went into web.config and searched for every occurance of 'Data Source' and replaced the . with my
connection string BRUCELAPTOP/SQLEXPRESS
 
Upon saving the web.config, the system ( I assume DevForce) requested to regenerate the model. I let it do so.
 
Then I ran it and the first query Get all customers works fine.
 
Thank you.
 
I am an experienced developer in old technologies (COBOL, etc) but just learning C# and LINQ.
 
I am going to have more questions on how to do some things. Do I post the questions here or can I talk to you directly?
 
Bruce
]]> Tue, 12 Jan 2010 09:51:34 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6071#6071 Prism Explorer-How to Install NorthwindEF Database : Hi Bruce- Glad you found the... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6067#6067 Author: WardBell
Subject: 1614
Posted: 11-Jan-2010 at 3:26pm

Hi Bruce-

Glad you found the NorthwindEF database in the zip; too many people miss this step!
 
Next I'd check to see if you can reach the DB. You can try while inside Visual Studio. From the EntityFramework model designer  (right click and pick "Update from Database"). Or via the Visual Studio "Server Explorer" window. 
 
Sometimes "Data Source=." doesn't work when "Data Source=localhost" does.
 
Then I'd look at permissions. There shouldn't be a problem because you're running as your windows identity but it's worth confirming that you can read the database at all.
 
Oops. I think I just saw it. You said you only have "SQL Server 2008 express " on your machine? If so, you need to change the "Data Source=." to "Data Source=YOUR-MACHINE-NAME\sql8express" or some such thing. Use a connection string that you know works as an example.
 
As a general practice, I test the connection string outside the application first.
 
Of course there is always a chance that something else is amiss. I hope this fixes your problem and that you can report good news.
 
W
]]> Mon, 11 Jan 2010 15:26:42 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6067#6067 Prism Explorer-How to Install NorthwindEF Database : ========== September 28, 2010... http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6054#6054 Author: BruceKu
Subject: 1614
Posted: 09-Jan-2010 at 1:50pm

==========  September 28, 2010 Update =========
 
Prism Explorer no longer uses NorthwindEF ... it uses the NorthwindIB tutorial database installed with DevForce 2010.
The documentation still says "NorthwindEF" ... which mistake will be corrected.
 
Ward's post below on 9/28/2010 describes the change.
 
========== Original Post ==================
 
I have brought down the Prism Explorer example and unzipped it into a directory.
I can open the project with VS2008. It runs.
 
But when I do Get All customers Query I get the error
 
A network-related or instance specific error occured while establishing a connection to SQL Server. The server was not found or inaccessible.
 
I use mainly SQL Server 2008 express on this machine so I did my usual for projects
1. Add App_Data directory for web project
2. added the existing dtatabase (as supplied in download) to directory
 
It is visible.
 
Checked in app.config (below)
 

<connectionStrings>

<add name="NorthwindEFEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.;Initial Catalog=NorthwindEF;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

</connectionStrings>

seems to suggest data source is local.
 
Got same error.
 
This is probably simple but I am not seeing how to connect to the database.
 
Can you help?
 
Thanks!
 
Bruce


Edited by WardBell - 28-Sep-2010 at 10:18am]]> Sat, 09 Jan 2010 13:50:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1614&PID=6054#6054