private SqlStream GetCreatedSqlStream(
TimeSpan?commandTimeout = null,
RecordTagAssociationManagementStrategy recordTagAssociationManagementStrategy = RecordTagAssociationManagementStrategy.AssociatedDuringPutInSprocInTransaction,
int?maxConcurrentHandlingCount = null,
SerializationFormat defaultSerializationFormat = SerializationFormat.Binary)
{
var sqlServerLocator = GetSqlServerLocator();
var resourceLocatorProtocol = new SingleResourceLocatorProtocols(sqlServerLocator);
var defaultSerializerRepresentation = GetSerializerRepresentation();
var stream = new SqlStream(
this.streamName,
TimeSpan.FromMinutes(1),
commandTimeout ?? TimeSpan.FromMinutes(3),
defaultSerializerRepresentation,
defaultSerializationFormat,
new JsonSerializerFactory(),
resourceLocatorProtocol);
stream.Execute(new StandardCreateStreamOp(stream.StreamRepresentation, ExistingStreamStrategy.Skip));
stream.Execute(new UpdateStreamStoredProceduresOp(recordTagAssociationManagementStrategy, maxConcurrentHandlingCount));
return(stream);
}
public void CreateStreamExampleDatabaseAndScripts()
{
var sqlServerLocator = new SqlServerLocator("localhost", "StreamExample3", "sa", "<password>", "SQLDEV2017");
var configuration = SqlServerDatabaseDefinition.BuildDatabaseConfigurationUsingDefaultsAsNecessary(sqlServerLocator.DatabaseName, @"D:\SQL\");
var createDatabaseOp = new CreateDatabaseOp(configuration, ExistingDatabaseStrategy.Throw);
var protocol = new SqlOperationsProtocol(sqlServerLocator);
protocol.Execute(createDatabaseOp);
var resourceLocatorProtocol = new SingleResourceLocatorProtocols(sqlServerLocator);
var configurationTypeRepresentation = typeof(NullJsonSerializationConfiguration).ToRepresentation();
SerializerRepresentation defaultSerializerRepresentation = new SerializerRepresentation(
SerializationKind.Json,
configurationTypeRepresentation);
var defaultSerializationFormat = SerializationFormat.String;
var stream = new SqlStream(
"Example",
TimeSpan.FromMinutes(1),
TimeSpan.FromMinutes(3),
defaultSerializerRepresentation,
defaultSerializationFormat,
new JsonSerializerFactory(),
resourceLocatorProtocol);
stream.Execute(new StandardCreateStreamOp(stream.StreamRepresentation, ExistingStreamStrategy.Skip));
this.testOutputHelper.WriteLine("Created database.");
/*
* var path = "D:/Temp/Example";
* var connectionString = sqlServerLocator.BuildConnectionString(TimeSpan.FromSeconds(20));
* Scripter.ScriptDatabaseToFilePath(connectionString, path, this.testOutputHelper.WriteLine, false);
*/
}
