Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 3.5 Website Programming Problem Design Solution
This is the forum to discuss the Wrox book ASP.NET 3.5 Website Programming Problem Design Solution by Chris Love; ISBN: 978-0-470-18758-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Website Programming Problem Design Solution section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 13th, 2010, 10:02 PM
Registered User
 
Join Date: Jun 2010
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default Invalid object name 'dbo.tbh_Articles'.

The Beerhouse app does not run!
Error:
Invalid object name 'dbo.tbh_Articles'.
  #2 (permalink)  
Old June 13th, 2010, 10:06 PM
Registered User
 
Join Date: Jun 2010
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default dbo.tbh_Articles object in BeerHouse DB????

The BeerHouse web app does not run.

It seems that does not have a table:

Server Error in '/BeerHouse35' Application.
--------------------------------------------------------------------------------

Invalid object name 'dbo.tbh_Articles'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.tbh_Articles'.

Source Error:


Line 169:
Line 170: Articlesctx.Articles.MergeOption = MergeOption.NoTracking;
Line 171: List<Article> lArticles = (Articlesctx.Articles.Include("Category")
Line 172: .Where(p => p.Active).Where(p => p.Approved).Where(p => p.Listed)
Line 173: .Where(p => p.ReleaseDate < DateTime.Now).OrderByDescending(lArticle => lArticle.AddedDate)).ToList();


Source File: C:\TheBeerHouse-C-3.5\TBHBLL\Articles\ArticleRepository.cs Line: 171

Stack Trace:


[SqlException (0x80131904): Invalid object name 'dbo.tbh_Articles'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +1950890
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +4846875
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +83
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteDbDataRead er(CommandBehavior behavior) +12
System.Data.Common.DbCommand.ExecuteReader(Command Behavior behavior) +10
System.Data.EntityClient.EntityCommandDefinition.E xecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +387

[EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details.]
System.Data.EntityClient.EntityCommandDefinition.E xecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) +423
System.Data.Objects.Internal.ObjectQueryExecutionP lan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +743
System.Data.Objects.ObjectQuery`1.GetResults(Nulla ble`1 forMergeOption) +157
System.Data.Objects.ObjectQuery`1.System.Collectio ns.Generic.IEnumerable<T>.GetEnumerator() +44
System.Collections.Generic.List`1..ctor(IEnumerabl e`1 collection) +7667702
System.Linq.Enumerable.ToList(IEnumerable`1 source) +61
TheBeerHouse.BLL.Articles.ArticleRepository.GetHom ePageArticles() in C:\Projects\ASP Sample Projects\TheBeerHouse-C-3.5\TBHBLL\Articles\ArticleRepository.cs:171
_Default.BindHomeArticles() in c:\Projects\ASP Sample Projects\TheBeerHouse-C-3.5\BeerHouse35\Default.aspx.cs:22
_Default.Page_Load(Object sender, EventArgs e) in c:\Projects\ASP Sample Projects\TheBeerHouse-C-3.5\BeerHouse35\Default.aspx.cs:12
System.Web.Util.CalliHelper.EventArgFunctionCaller (IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Cal lback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
TheBeerHouse.UI.BasePage.OnLoad(EventArgs e) in C:\Projects\ASP Sample Projects\TheBeerHouse-C-3.5\TBHBLL\UI\BasePage.cs:145
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627




--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3607; ASP.NET Version:2.0.50727.3614
  #3 (permalink)  
Old June 13th, 2010, 10:14 PM
nberardi's Avatar
Wrox Author
 
Join Date: Aug 2008
Location: Phoenixville, PA, USA
Posts: 102
Thanks: 1
Thanked 16 Times in 16 Posts
Send a message via AIM to nberardi
Default

You are in the wrong forum. This is the BeerHouse MVC forum. You want the ASP.NET 3.5 Beer House forum. I will not be able to help you with this code.
__________________
Check out my blog at: http://www.coderjournal.com
The Following User Says Thank You to nberardi For This Useful Post:
jminatel (June 14th, 2010)
  #4 (permalink)  
Old June 13th, 2010, 10:19 PM
Registered User
 
Join Date: Jun 2010
Posts: 9
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Where is "ASP.NET 3.5 Beer House forum"?
  #5 (permalink)  
Old June 14th, 2010, 08:33 AM
jminatel's Avatar
Wrox Staff
Points: 18,940, Level: 59
Points: 18,940, Level: 59 Points: 18,940, Level: 59 Points: 18,940, Level: 59
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Location: Indianapolis, IN, USA.
Posts: 1,945
Thanks: 73
Thanked 139 Times in 101 Posts
Default

I've moved your question to the right forum now. Hope this helps.
__________________
Jim Minatel
Associate Publisher, WROX - A Wiley Brand
Did someone here help you? Click on their post!
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot insert duplicate key row in object 'dbo.mov alxGramma SQL Server 2005 4 April 15th, 2008 01:42 PM
invalid object dbo.split error............ hepsy.i ASP.NET 1.0 and 1.1 Professional 1 August 8th, 2007 06:31 PM
valid dbo; permission to impersonate dbo est BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 5 February 21st, 2007 04:44 AM
Invalid Object Name busybee ASP.NET 1.0 and 1.1 Professional 1 July 5th, 2006 11:13 PM
Invalid object name Syed Naveed Khursheed BOOK: Beginning ASP 3.0 8 November 20th, 2004 01:42 AM



All times are GMT -4. The time now is 01:30 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.