Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DataContext.CreateDatabase Method

Creates a database on the server.

Namespace:  System.Data.Linq
Assembly:  System.Data.Linq (in System.Data.Linq.dll)

'Declaration
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
Show:
© 2015 Microsoft