private void GenerateCreateUserWithLogin(CreateUserWithLoginOperation operation)
{
if (operation != null)
{
using (var writer = Writer())
{
writer.WriteLine("IF NOT EXISTS (SELECT loginname from master.dbo.syslogins WHERE name = '{0}')", operation.Username);
writer.WriteLine("BEGIN");
writer.WriteLine(" CREATE LOGIN {0} WITH PASSWORD = '******';", operation.Username, operation.Password);
writer.WriteLine("END");
writer.WriteLine("CREATE USER {0} FROM LOGIN {0};", operation.Username);
Statement(writer);
}
}
}
protected override void Generate(CreateUserWithLoginOperation createUserWithLoginOperation)
{
base.Generate(createUserWithLoginOperation);
this.GenerateCreateUserWithLogin(createUserWithLoginOperation);
}