The Beerhouse app does not run!
Error:
Invalid object name 'dbo.tbh_Articles'.

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

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

Where is "ASP.NET 3.5 Beer House forum"?

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!