Duration (Pacific Standard Time):
To (Pacific Standard Time):
Impact:
  • None
User Action:
  • None
.NET Framework Class Library

DataContext.CreateDatabase Method

Creates a database on the server.

Namespace:  System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)
Public Sub CreateDatabase

The name of the database is derived by using the following algorithm:

  • If a database is identified in the connection string, its name is used.

  • If a DatabaseAttribute attribute is present, its Name property is used as the name of the database.

  • If there is no database tag in the connection string and a strongly typed DataContext is used, a database that has the same name as the DataContext inheriting class is checked.

  • If a weakly typed DataContext is used, an exception is thrown.

  • If the DataContext has been created by using a file name, the database corresponding to that file name is created.

The following code shows how to set up a temporary database and then remove it.

If Not db.DatabaseExists Then
    db.CreateDatabase()
End If 
' ...
db.DeleteDatabase()

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5

.NET Framework Client Profile

Supported in: 4