Where is the db/table generated by Entity Framework?

Question

I am learning MVC 4 from O'Reilly book (Programming ASP.NET MVC4) and have followed its steps so now have a class as:

public class Auction
{
    public long Id { get; set; }
    public string Title { get; set; }
    public string Description { get; set; }
    public decimal StartPrice { get; set; }
    public decimal CurrentPrice { get; set; }
    //[Column(TypeName = "DateTime2")]
    public DateTime StartTime { get; set; }
    //[Column(TypeName = "DateTime2")]
    public DateTime EndTime { get; set; }
}

and as you know better I have to go with EF (eh) and when I run the code I get and error as

The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. The statement has been terminated.

Yes, I know it is here on SOF and discussed but from the answers on SOF I found that i can do a conversion in the table. As you see I have commented out the attributes in the class since using them leads me to a new error as:

The model backing the 'eBayDataContext' context has changed since the database was created. Consider using Code First Migrations to update the database (http://go.microsoft.com/fwlink/?LinkId=238269).

Beside this situation: I cannot see any DB or table made in SQL Server. How can I locate the table/DB generated by EF? I have checked but nothing I do see here!

This is my connectionString

  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;Initial Catalog=aspnet-eBay-20140404154307;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnet-eBay-20140404154307.mdf" providerName="System.Data.SqlClient" />
  </connectionStrings>

Thank you.

Craig · Accepted Answer · 2014-04-08 20:42:29Z

1

In Visual Studio 2010:

View --> Server Explorer
Click Connect to Database icon.
Leave defaults and enter (LocalDb)\v11.0 for the Server name field.
In the Connect to a database section at the bottom, click the down arrow for the dropdownlist (Select or enter a database name:) It will take a few seconds, but then you should see your database listed there (aspnet-eBay-20140404154307)
Select your database and click OK.

You'll now have a new connection to your database in the Server Explorer window. You can expand this connection and navigate to your Tables.

answered Apr 8, 2014 at 20:42

Craig

2181 silver badge11 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Razvan Dumitru Over a year ago

You must wrote ur server name in the list, not search for that.

amit kohan Over a year ago

Thanks but can you be more specific?

amit kohan Over a year ago

@Craig Thanks I followed that but there is no such a name in drop-down list. any idea? the reason I think the Db/Table are created is because when I change my class it throws: **The model backing the 'eBayDataContext' context has changed since the database was created. Consider using Code First Migrations to update the database (go.microsoft.com/fwlink/?LinkId=238269). **

amit kohan Over a year ago

OK finally after several minutes it showed up!!! i am new to EF but by far it acts strange and I'm not crazy about it

Collectives™ on Stack Overflow

Where is the db/table generated by Entity Framework?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related