یکی از اهداف ORMها توانایی تغییر نوع بانک اطلاعاتی است در پروژههای بزرگ با روابط بین موجودیتی و ساختار کدنویسی پیچیده ORM ای مانند EF محدودیتهای فراوانی ایجاد میکند که این کار را عملا ناممکن یا حداقل طاقت فرسا میکند .
{
"dependencies": {
"Microsoft.Extensions.Caching.SqlServer": "1.1.0"
},
"tools": {
"Microsoft.Extensions.Caching.SqlConfig.Tools": "1.1.0-preview4-final"
}
} dotnet sql-cache create "Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=sql_cache;Integrated Security=True;" "dbo" "AppSqlCache"
CREATE TABLE AppSqlCache ( Id NVARCHAR (449) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL, Value VARBINARY (MAX) NOT NULL, ExpiresAtTime DATETIMEOFFSET NOT NULL, SlidingExpirationInSeconds BIGINT NULL, AbsoluteExpiration DATETIMEOFFSET NULL, CONSTRAINT pk_Id PRIMARY KEY (Id) ); CREATE NONCLUSTERED INDEX Index_ExpiresAtTime ON AppSqlCache(ExpiresAtTime);
public class AppSqlCache
{
public string Id { get; set; }
public byte[] Value { get; set; }
public DateTimeOffset ExpiresAtTime { get; set; }
public long? SlidingExpirationInSeconds { get; set; }
public DateTimeOffset? AbsoluteExpiration { get; set; }
} public class MyDBDataContext : DbContext
{
public virtual DbSet<AppSqlCache> AppSqlCache { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<AppSqlCache>(entity =>
{
entity.ToTable(name: "AppSqlCache", schema: "dbo");
entity.HasIndex(e => e.ExpiresAtTime).HasName("Index_ExpiresAtTime");
entity.Property(e => e.Id).HasMaxLength(449);
entity.Property(e => e.Value).IsRequired();
});
}
} public void ConfigureServices(IServiceCollection services)
{
services.AddDistributedSqlServerCache(options =>
{
options.ConnectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=sql_cache;Integrated Security=True;";
options.SchemaName = "dbo";
options.TableName = "AppSqlCache";
}); public IActionResult Index()
{
HttpContext.Session.SetString("User", "VahidN");
return Json(true);
}
public IActionResult About()
{
var userContent = HttpContext.Session.GetString("User");
return Json(userContent);
} 
services.Add(ServiceDescriptor.Singleton<IDistributedCache, SqlServerCache>());
using System;
using System.Text;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.Caching.Distributed;
namespace Core1RtmEmptyTest.Controllers
{
public class CacheTestController : Controller
{
readonly IDistributedCache _cache;
public CacheTestController(IDistributedCache cache)
{
_cache = cache;
}
public IActionResult SetCacheData()
{
var time = DateTime.Now.ToLocalTime().ToString();
var cacheOptions = new DistributedCacheEntryOptions
{
AbsoluteExpiration = DateTime.Now.AddYears(1)
};
_cache.Set("Time", Encoding.UTF8.GetBytes(time), cacheOptions);
return View();
}
public IActionResult GetCacheData()
{
var time = Encoding.UTF8.GetString(_cache.Get("Time"));
ViewBag.data = time;
return View();
}
public bool RemoveCacheData()
{
_cache.Remove("Time");
return true;
}
}
} Value VARBINARY (MAX) NOT NULL,
public byte[] Value { get; set; } 
<distributed-cache name="MyCacheItem2" expires-sliding="TimeSpan.FromMinutes(30)"> <p>From distributed-cache</p> @DateTime.Now.ToString() </distributed-cache>
{"Cannot open database \"kashanSchools\" requested by the login. The login failed.\r\nLogin failed for user 'ALIPC\\ali'."} <add name="DefaultConnection" connectionString="Server=. Database=kashanSchools;Trusted_Connection=True;" providerName="System.Data.SqlClient" />
Visual Studio, like any Integrated Development Environment, can host extensions for more specialist languages or development tasks. This sort of work is reasonably straightforward most of the time but occasionally you need functionality that isn't available in the APIs. Michal takes two examples, printing code in an editing window, and gaining access to the Visual Studio Notifications, and explains how to hack Visual Studio to get to the functionality.
using Parbad.Builder;
public void ConfigureServices(IServiceCollection services)
{
services.AddMvc();
services.AddParbad()
// .configurations
// .configurations
// .configurations
} using Parbad.Builder;
public class Startup
{
public void Configuration(IAppBuilder app)
{
ParbadBuilder.CreateDefaultBuilder()
// .configurations
// .configurations
// .configurations
}
} services.AddParbad()
.ConfigureGateways(gateways =>
{
gateways
.AddMellat()
.WithOptions(options =>
{
options.TerminalId = 123;
options.UserName = "MyId";
options.UserPassword = "MyPassword";
});
}); public class MellatOptionsProvider : IParbadOptionsProvider<MellatGatewayOptions>
{
private readonly IMySettingsService _settingsService;
public MellatOptionsProvider(IMySettingsService settingsService)
{
_settingsService = settingsService;
}
public void Provide(MellatGatewayOptions options)
{
var settings = _settingsService.GetSettings();
options.TerminalId = settings.TerminalId;
options.UserName = settings.UserName;
options.UserPassword = settings.UserPassword;
}
} services.AddParbad()
.ConfigureGateways(gateways =>
{
gateways
.AddMellat()
.WithOptionsProvider<MellatOptionsProvider>(ServiceLifetime.Transient);
}); services.AddParbad()
.ConfigureGateways(gateways =>
{
gateways
.AddMellat()
.WithConfiguration(IConfiguration.GetSection("Mellat");
}); "Mellat": {
"TerminalId": 123,
"UserName": "MyUsername",
"UserPassword": "MyPassword"
} ParbadBuilder.CreateDefaultBuilder()
.ConfigureHttpContext(builder => builder.UseOwinFromCurrentHttpContext()); services.AddParbad()
.ConfigureHttpContext(builder => builder.UseDefaultAspNetCore()); services.AddParbad()
.ConfigureStorage(builder => builder.UseParbadSqlServer("ConnectionString")); services.AddParbad()
.ConfigureStorage(builder => builder.UseInMemoryDatabase("MyMemoryName")); services.AddParbad()
.ConfigureMessages(options =>
{
options.PaymentSucceed = "Payment was successful.";
options.PaymentFailed = "Payment was not successful.";
// other messages...
});