Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
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'.
 
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
 
Old June 13th, 2010, 10:14 PM
nberardi's Avatar
Wrox Author
 
Join Date: Aug 2008
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)
 
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"?
 
Old June 14th, 2010, 08:33 AM
jminatel's Avatar
Wrox Staff
Points: 18,059, Level: 58
Points: 18,059, Level: 58 Points: 18,059, Level: 58 Points: 18,059, Level: 58
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2003
Posts: 1,906
Thanks: 62
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!





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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.