How to set initSql of BackendConfiguration in code?

[Richard Koslik]

Hello,

how can i set the initial sql command after the db connection in the code.

I want to do it somewhere here...

protected override MyDomainContext CreateDataContext()
{
    XmlMetadataSource metadataSource = XmlMetadataSource.FromAssemblyResource("MyTables.rlinq");
    string connectionString = string.Empty;
    BackendConfiguration dbConfig = new BackendConfiguration();

    dbConfig.initSql = ?????????????
.
.
.

    return new MyDomainContext(connectionString, dbConfig, metadataSource);
}

But i can't find the property to store the sql command.
Where can it be done in code?

Thanks,
Richard.

[Zoran]

Hi Richard Koslik,

 The API in the BackendConfiguration settings are is split in few categories for more clear usage like: Runtime, Logging, ConnectionPool etc.
The InitSQL setting is under the ConnectionPool settings so the code you should be using is the following:

dbConfig.ConnectionPool.InitSQL.Add("Sample Statement");

This way you are able to specify more than one initSQL statement for your connections.

Greetings,
Zoran
the Telerik team