public int RegisterRoles()
{
var queryString =
"SET IDENTITY_INSERT[dbo].[Roles] ON " +
"INSERT INTO[dbo].[Roles] ([RoleId], [Name]) VALUES(1, 'User'); " +
"INSERT INTO[dbo].[Roles] ([RoleId], [Name]) VALUES(2, 'User,Moder'); " +
"INSERT INTO[dbo].[Roles] ([RoleId], [Name]) VALUES(3, 'User,Moder,Admin'); " +
"SET IDENTITY_INSERT[dbo].[Roles] OFF; ";
using (SqlConnection connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
try
{
connection.Open();
return command.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
}
}
}