Launching a new database-enabled application

Question

I am launching a new C # project that uses a database, but I want all of this to be versioned. I am thinking of a SQL Server database (if I create an mdf file, can I use it on a computer without installing SQL Server?) And LINQ to SQL.

How do you usually start such a project? Do you create a .sql file to create a database and then create linq models? Is there a better way?

Answer 1

It really depends on what you prefer. You will get answers that tell you better to first design your object model (programmers will tell you this), and then there are those who are going to tell you first about the development of your data model (database administrators).

In the end, the right way is what you are most comfortable with. If you feel that you are going to do most of the manipulation of data in code, then it may be useful for you to start with an object model. If you feel that you are doing most of the data operations, then it will be useful for you to start with a database.

, , sql , , , db . , , . , , , .

, , , .

Answer 2

: , sql, , , .

-: , MDF . , sql- .

-: , ​​ FluentNHibernate NHibernate, - sql, / .

Answer 3

.mdf, SQL Server. () SQL Server Express.

, , . , .

, , , Visual Studio. , . , .., , . , ​​ RikMigrations. Visual Studio ( , "Team Developer" Sku) ..