AutoCreateOption Enum

Lists the values that specify the action which is performed when a session is connected to a data store.

Namespace: DevExpress.Xpo.DB

Assembly: DevExpress.Data.v18.1.dll

Declaration

C#

public enum AutoCreateOption

VB.NET

Public Enum AutoCreateOption

Members

Name	Description
DatabaseAndSchema	A session will try to automatically create the database if it doesn’t exist. It will also create or update the database schema for any persistent classes currently being used.
SchemaOnly	A session will automatically create or update the database schema for the persistent classes currently being used. If the database doesn’t exist, it won’t be created by a session.
None	A session will not automatically create the database or update the database schema. The database schema is still queried and checked to match the currently used persistent class metadata.
SchemaAlreadyExists	A session will never query the database for schema to validate against persistent class metadata. This will suppress the SchemaCorrectionNeededException, but a database error may occur during data operations if the schema is not compatible with run-time persistent classes metadata.

Related API Members

The following properties accept/return AutoCreateOption values:

Show 13 items

Library	Related API Members
Cross-Platform Class Library	DataCacheBase.AutoCreateOption
	DataCacheNode.AutoCreateOption
	DataCacheRoot.AutoCreateOption
	DataStoreBase.AutoCreateOption
	IDataStore.AutoCreateOption
eXpress Persistent Objects	AccessConnectionProviderMultiUserThreadSafe.AutoCreateOption
	IDataLayer.AutoCreateOption
	IObjectLayerEx.AutoCreateOption
	MSSql2005SqlDependencyCacheRoot.AutoCreateOption
	SerializableObjectLayerClient.AutoCreateOption
	Session.AutoCreateOption
	SessionObjectLayer.AutoCreateOption
	SimpleObjectLayer.AutoCreateOption

Remarks

The values listed by this enumeration can be used when instantiating a Data Access Layer. Additionally, you can set the mode for a specific Session, using the Session.AutoCreateOption property.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the AutoCreateOption enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

XPO_tutorial-1-your-first-data-aware-application-with-xpo-e4555/CS/XpoTutorial1/MyDataModelCode/ConnectionHelper.cs#L15

public const string ConnectionString = @"XpoProvider=MSSqlServer;data source=(local);integrated security=SSPI;initial catalog=XpoTutorial1";
public static void Connect(DevExpress.Xpo.DB.AutoCreateOption autoCreateOption) {
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);

XPO_tutorial-2-relations-one-to-many-e4557/CS/XpoTutorial2/MyDataModelCode/ConnectionHelper.cs#L15

public const string ConnectionString = @"XpoProvider=MSSqlServer;data source=(local);integrated security=SSPI;initial catalog=XpoTutorial2";
public static void Connect(DevExpress.Xpo.DB.AutoCreateOption autoCreateOption) {
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);

XPO_tutorial-3-querying-data-e4559/CS/XpoTutorial3/MyDataModelCode/ConnectionHelper.cs#L15

public const string ConnectionString = @"XpoProvider=MSSqlServer;data source=(local);integrated security=SSPI;initial catalog=XpoTutorial3";
public static void Connect(DevExpress.Xpo.DB.AutoCreateOption autoCreateOption) {
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);

XPO_how-to-reopen-a-broken-connection-when-using-a-postgresql-database-e3086/CS/Program.cs#L11

    "user id=postgres;password=admin;server=donchakDBFarm;database=XpoUnitTests;port=5434",
    AutoCreateOption.DatabaseAndSchema
);

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/CS/MsSqlWithCte.cs#L14

#region infrastructure
public MSSqlConnectionProviderWithCte(IDbConnection connection, AutoCreateOption autoCreateOption)
    : base(connection, autoCreateOption) { }

VB.NET

XPO_tutorial-1-your-first-data-aware-application-with-xpo-e4555/VB/XpoTutorial1/MyDataModelCode/ConnectionHelper.vb#L18

Public Const ConnectionString As String = "XpoProvider=MSSqlServer;data source=(local);integrated security=SSPI;initial catalog=XpoTutorial1"
Public Shared Sub Connect(ByVal autoCreateOption As DevExpress.Xpo.DB.AutoCreateOption)
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption)

XPO_tutorial-2-relations-one-to-many-e4557/VB/XpoTutorial2/Program.vb#L16

Shared Sub Main()
    ConnectionHelper.Connect(AutoCreateOption.DatabaseAndSchema)
    Application.EnableVisualStyles()

XPO_tutorial-3-querying-data-e4559/VB/XpoTutorial3/MyDataModelCode/ConnectionHelper.vb#L19

End Sub
Public Shared Sub Connect(ByVal autoCreateOption As DevExpress.Xpo.DB.AutoCreateOption)
    XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption)

XPO_how-to-reopen-a-broken-connection-when-using-a-postgresql-database-e3086/VB/Program.vb#L9

SafePostgreSqlConnectionProvider.Register()
Dim dataStore As New SafePostgreSqlConnectionProvider("user id=postgres;password=admin;server=donchakDBFarm;database=XpoUnitTests;port=5434", AutoCreateOption.DatabaseAndSchema)
Dim dal As IDataLayer = New SimpleDataLayer(dataStore)

XPO_how-to-use-custom-sql-queries-as-a-data-source-in-xpo-via-common-table-expressions-cte-e3468/VB/MsSqlWithCte.vb#L16

#Region "infrastructure"
Public Sub New(ByVal connection As IDbConnection, ByVal autoCreateOption As AutoCreateOption)
    MyBase.New(connection, autoCreateOption)