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); }