[ask] asp.net mvc 2 - crud

[SinggahDapur]

Halo teman2,

saya sedang membuat website yang berbasiskan ASP.NET MVC 2

Setelah saya melakukan create table untuk database, saya hendak menampilkan isi dari tabel tersebut. Untuk itu, saya gunakan "scaffold"nya ASP.NET untuk secara otomatis generate viewnya. Namun terdapat error ketika berusaha meload page untuk menampilkan isi tabel tersebut.

Adapun pesan errornya adalah


Code:

Server Error in '/' Application.
Invalid object name 'dbo.Accommodations'.
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.Accommodations'.

Source Error:

Line 41:
Line 42:
Line 43:
Line 44:
Line 45:


Source File: d:\MyProject\Views\Accommodation\Index.aspx Line: 43

Stack Trace:

[SqlException (0x80131904): Invalid object name 'dbo.Accommodations'.]
System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaDat a() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
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) +443

[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) +479
System.Data.Objects.Internal.ObjectQueryExecutionP lan.Execute(ObjectContext context, ObjectParameterCollection parameterValues) +736
System.Data.Objects.ObjectQuery`1.GetResults(Nulla ble`1 forMergeOption) +149
System.Data.Objects.ObjectQuery`1.System.Collectio ns.Generic.IEnumerable.GetEnumerator() +44
ASP.views_accommodation_index_aspx.__RenderContent 2(HtmlTextWriter __w, Control parameterContainer) in d:\MyProject\Views\Accommodation\Index.aspx:43
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +109
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +8
System.Web.UI.Control.Render(HtmlTextWriter writer) +10
System.Web.UI.Control.RenderControlInternal(HtmlTe xtWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
ASP.views_shared_site_master.__Render__control1(Ht mlTextWriter __w, Control parameterContainer) in d:\MyProject\Views\Shared\Site.Master:26
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +109
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +8
System.Web.UI.Control.Render(HtmlTextWriter writer) +10
System.Web.UI.Control.RenderControlInternal(HtmlTe xtWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Control.RenderChildrenInternal(HtmlT extWriter writer, ICollection children) +208
System.Web.UI.Control.RenderChildren(HtmlTextWrite r writer) +8
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.Mvc.ViewPage.Render(HtmlTextWriter writer) +56
System.Web.UI.Control.RenderControlInternal(HtmlTe xtWriter writer, ControlAdapter adapter) +27
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3060

sedangkan untuk syntax create tablenya adalah sebagai berikut


Code:

-- Creating table 'Accommodations'
CREATE TABLE [dbo].[Accommodations] (
[ID] int IDENTITY(1,1) NOT NULL,
[Name] varchar(63) NOT NULL,
[Star] smallint NOT NULL,
[Price] decimal(10,2) NOT NULL,
[Address] varchar(63) NOT NULL,
[City] varchar(63) NULL,
[Province] varchar(63) NULL,
[Phone] varchar(31) NULL,
[Description] varchar(max) NULL
);
GO

saya udah berusaha untuk google tapi masih belum nemu solusinya.. ada yang bilang masalah permission, tapi entah bener apa nggak ? mungkin master2 ASP di sini bisa bantu..