The difference between MVC2, MVC3, MVC4,MVC5, and the different versions of EF; What's a localdb?

EF6 in code First mode, Codefrist does not support more databases, such as the Access,sqlite,sql compact 3.5,mysql,oracle

Introduction to LocalDB

Similar to SQLite (but SQLite does not support stored procedures, while LOCALDB supports stored procedures)

Guide: LocalDB is a new feature of SQL Server 2012, a lightweight database specifically tailored to the needs of developers. This article will explain LocalDB's development background, showcase its core features, and see how it differs from other lightweight databases from Microsoft.

What is LocalDB

With the release of SQL Server 2012, LocalDB jumps into our line of sight, which can be seen as a lightweight version of SQL Server Express.

LocalDB is created specifically for developers, it's very easy to install, almost no management, compatible with the T-SQL language, programming interfaces with SQL Server Express indistinguishable.

With LocalDB, developers don't need to install and maintain a large instance of SQL Server on their notebooks. In addition, the LOCALDB is also suitable for small application environments where developers can use it for small production environments or embedded environments.

Tailor-Made for developers

Before we look at the technical details of LOCALDB, let's look at the background to build LocalDB.

SQL Server Express has been meeting both of our needs for a long time. It is both a free version of SQL Server and powerful enough to be compatible with other versions. Of course, its capabilities also have some limitations, that is, its storage capacity of each database can not exceed 10G.

As a mature database product, SQL Server still has a fairly complex express version. But as developers, we prefer to reduce the complexity of management and focus on development.

The development goals of LOCALDB, which are lightweight SQL Server Express, are tailored for developers.

Core Technical Features

Having said so much, now let's look at the core technical features of LOCALDB:

• Compatible with other versions of SQL Server, using Sqlservr.exe as a service process, using the same client access interface (such as ADO, ODBC, or PDO), compatible with the T-SQL programming language.
• You do not have to install multiple localdb on the same computer, and different applications can execute multiple LOCALDB processes in parallel, but all processes are started from the same executable file (Sqlservr.exe).
• LocalDB does not create any system services, and the LOCALDB process automatically starts and stops as needed. The application simply connects to "Data source= (LocalDB) \v11.0", and LocalDB is started as a child of the application. As the connection terminates, the LOCALDB process also stops.
• LocalDB supports the AttachDbFileName property, which allows the developer to specify the database file location. For example:

1. Data Source = (localdb) \v11.0;
2. Integrated Security = true;
3. AttachDbFileName = C:\MyData\Database1.mdf

Lightweight database comparison (LocalDB vs. SQL Express vs. Compact)

LocalDB is not a complete replacement for SQL Server Express, it simply provides a different option for developers and guarantees consistent compatibility with SQL Server Express.

There is a big difference between localdb and the SQL Server compact:

operating mode: The SQL Server Compact is an in-process (In-proc) dll,localdb that runs as a standalone process.

disk occupancy: The SQL Server Compact has a volume of only 140MB after the 4MB,LOCALDB installation.

Functional Features: The SQL Server Compact provides only the core functionality of the RDBMS, while LocalDB provides richer functionality, such as stored procedures, geometries, and geographic data types.

The final thought

LocalDB as a feature-rich lightweight database, it's definitely worth trying. Next, we might wonder if the localdb provides a good management interface? The answer is yes.

LOCALDB provides a command-line administration tool, SqlLocalDB.exe. Next time, let's explore how to use the command-line utility SqlLocalDB.exe and SQL Server Management Studio (SSMS) to manage LocalDB. (Computer/compile)

Original link: Introducing LocalDB, an improved SQL Express

Download Link: SQL Server Express & LocalDB

LocalDB is not about replacing SQL Express, but for developers to spend minimal effort on developing applications. Microsoft will continue to provide users with a free SQL Server shortcut, which they can run on a small evaluation project with a database size limit of 10GB.