namespace ASPNETCoreIdentitySample.DataLayer.Mappings
{
public class RoleConfiguration : IEntityTypeConfiguration<Role>
{
private readonly SiteSettings _siteSettings;
private readonly ILookupNormalizer _keyNormalizer;
public RoleConfiguration(SiteSettings siteSettings, ILookupNormalizer keyNormalizer)
{
_siteSettings = siteSettings ?? throw new ArgumentNullException(nameof(siteSettings));
_keyNormalizer = keyNormalizer ?? throw new ArgumentNullException(nameof(keyNormalizer));
}
public void Configure(EntityTypeBuilder<Role> builder)
{
builder.ToTable("AppRoles");
var adminUserSeed = _siteSettings.AdminUserSeed;
builder.HasData(
new Role
{
Id = 1,
Name = adminUserSeed.RoleName,
NormalizedName = _keyNormalizer.NormalizeName(adminUserSeed.RoleName),
ConcurrencyStamp = Guid.NewGuid().ToString()
});
}
}
} public class UserConfiguration : IEntityTypeConfiguration<User>
{
private readonly SiteSettings _siteSettings;
private readonly ILookupNormalizer _keyNormalizer;
private readonly IPasswordHasher<User> _passwordHasher;
public UserConfiguration(
SiteSettings siteSettings,
ILookupNormalizer keyNormalizer,
IPasswordHasher<User> passwordHasher)
{
_siteSettings = siteSettings ?? throw new ArgumentNullException(nameof(siteSettings));
_keyNormalizer = keyNormalizer ?? throw new ArgumentNullException(nameof(keyNormalizer));
_passwordHasher = passwordHasher ?? throw new ArgumentNullException(nameof(passwordHasher));
}
public void Configure(EntityTypeBuilder<User> builder)
{
builder.ToTable("AppUsers");
var adminUserSeed = _siteSettings.AdminUserSeed;
builder.HasData(
new User
{
Id = 1,
UserName = adminUserSeed.Username,
NormalizedUserName = _keyNormalizer.NormalizeName(adminUserSeed.Username),
Email = adminUserSeed.Email,
NormalizedEmail = _keyNormalizer.NormalizeEmail(adminUserSeed.Email),
EmailConfirmed = true,
IsEmailPublic = true,
LockoutEnabled = true,
TwoFactorEnabled = false,
PasswordHash = _passwordHasher.HashPassword(null, adminUserSeed.Password),
ConcurrencyStamp = Guid.NewGuid().ToString(),
SecurityStamp = string.Empty,
IsActive = true
});
}
} public class UserRoleConfiguration : IEntityTypeConfiguration<UserRole>
{
public void Configure(EntityTypeBuilder<UserRole> builder)
{
builder.HasOne(userRole => userRole.Role)
.WithMany(role => role.Users)
.HasForeignKey(userRole => userRole.RoleId);
builder.HasOne(userRole => userRole.User)
.WithMany(user => user.Roles)
.HasForeignKey(userRole => userRole.UserId);
builder.ToTable("AppUserRoles");
builder.HasData(
new UserRole
{
UserId = 1,
RoleId = 1
});
}
} public class ApplicationDbContextFactory : IDesignTimeDbContextFactory<ApplicationDbContext>
{
public ApplicationDbContext CreateDbContext(string[] args)
{
// ....
services.TryAddScoped<ILookupNormalizer, UpperInvariantLookupNormalizer>();
services.TryAddScoped<IPasswordHasher<User>, PasswordHasher<User>>(); using Microsoft.EntityFrameworkCore.Infrastructure;
namespace ASPNETCoreIdentitySample.DataLayer.Context
{
public class ApplicationDbContext :
IdentityDbContext<User, Role, int, UserClaim, UserRole, UserLogin, RoleClaim, UserToken>,
IUnitOfWork
{
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
: base(options) { }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
var siteSettings = this.GetService<IOptionsSnapshot<SiteSettings>>()?.Value;
var lookupNormalizer = this.GetService<ILookupNormalizer>();
var passwordHasher = this.GetService<IPasswordHasher<User>>()
modelBuilder.ApplyConfiguration(new RoleConfiguration(siteSettings, lookupNormalizer));
modelBuilder.ApplyConfiguration(new UserConfiguration(siteSettings, lookupNormalizer, passwordHasher));
modelBuilder.ApplyConfiguration(new UserUsedPasswordConfiguration(siteSettings, passwordHasher));
// ... dotnet ef migrations --startup-project ../ASPNETCoreIdentitySample/ add V1
Columnstore indexes were first introduced in SQL Server 2012. They are a new way to store the data from a table that improves the performance of certain query types by at least ten times. They are especially helpful with fact tables in data warehouses.
برای کپی کردن فایل mdf و فایل ldf ، یک بانک اطلاعاتی ، بدون این که سرویس SQL Server را متوقف کنیم و یا این که آن بانک اطلاعاتی را Detach کنیم ، می‌توانیم از نرم افزار HoboCopy.exe استفاده نمایید . برای این کار ابتدا این فایل را در یک مسیری کپی نمایید . به طور مثال آن را در مسیر C:\Windows\System32 کپی کنید . سپس وارد PowerShell شوید . البته باید به صورت Run as administrator این کار را انجام دهید .
سپس در آن مسیر نام فایل اجرای HoboCopy و سپس آدرس فایل مبداء (آدرس فایل‌های بانک اطلاعاتی) و در نهایت آدرس فولدری که بناست اطلاعات mdf و ldf در آنجا کپی شوند . i:\MyDB آدرس مبداء می‌باشد و آدرس i:\My ، آدرس مقصد می‌باشد .
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
Data Source=.\\SQLEXPRESS;Initial Catalog=MyTestDb;Integrated Security=true;Encrypt=False;
update products set Name = "Test" Where Id = 1
update products with (nolock,updlock) set Name = "Test" where Id = 1
public class UpdateRowLockHintDbCommandInterceptor : IDbCommandInterceptor
{
public void NonQueryExecuting(DbCommand command, DbCommandInterceptionContext<Int32> interceptionContext)
{
if (command.CommandType != CommandType.Text) return; // (1)
if (!(command is SqlCommand)) return; // (2)
SqlCommand sqlCommand = (SqlCommand)command;
String commandText = sqlCommand.CommandText;
String updateCommandRegularExpression = "(update) ";
Boolean isUpdateCommand = Regex.IsMatch(commandText, updateCommandRegularExpression, RegexOptions.IgnoreCase | RegexOptions.Multiline); // You may use better regular expression pattern here.
if (isUpdateCommand)
{
Boolean isSnapshotIsolationTransaction = sqlCommand.Transaction != null && sqlCommand.Transaction.IsolationLevel == IsolationLevel.Snapshot;
String tableHintToAdd = isSnapshotIsolationTransaction ? " with (rowlock , updlock) set " : " with (rowlock) set ";
commandText = Regex.Replace(commandText, "^(set) ", (match) =>
{
return tableHintToAdd;
}, RegexOptions.IgnoreCase | RegexOptions.Multiline);
command.CommandText = commandText;
}
}