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...
}); 
CREATE TABLE xmlInvoice ( invoiceId INT IDENTITY PRIMARY KEY, invoice XML )
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1000" dept="hardware">
<CustomerName>Vahid</CustomerName>
<LineItems>
<LineItem><Description>Gear</Description><Price>9.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1002" dept="garden">
<CustomerName>Mehdi</CustomerName>
<LineItems>
<LineItem><Description>Shovel</Description><Price>19.2</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1003" dept="garden">
<CustomerName>Mohsen</CustomerName>
<LineItems>
<LineItem><Description>Trellis</Description><Price>8.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1004" dept="hardware">
<CustomerName>Hamid</CustomerName>
<LineItems>
<LineItem><Description>Pen</Description><Price>1.5</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1005" dept="IT">
<CustomerName>Ali</CustomerName>
<LineItems>
<LineItem><Description>Book</Description><Price>3.2</Price></LineItem>
</LineItems>
</Invoice>
')
INSERT INTO xmlInvoice
VALUES('
<Invoice InvoiceId="1006" dept="hardware">
<CustomerName>Reza</CustomerName>
<LineItems>
<LineItem><Description>M.Board</Description><Price>19.5</Price></LineItem>
</LineItems>
</Invoice>
') CREATE XML SCHEMA COLLECTION invoice_xsd AS
' <xs:schema attributeFormDefault="unqualified"
elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="Invoice">
<xs:complexType>
<xs:sequence>
<xs:element name="CustomerName" type="xs:string" />
<xs:element name="LineItems">
<xs:complexType>
<xs:sequence>
<xs:element name="LineItem">
<xs:complexType>
<xs:sequence>
<xs:element name="Description" type="xs:string" />
<xs:element name="Price" type="xs:decimal" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="InvoiceId" type="xs:unsignedShort" use="required" />
<xs:attribute name="dept" type="xs:string" use="required" />
</xs:complexType>
</xs:element>
</xs:schema>'
Go
CREATE TABLE xmlInvoice2
(
invoiceId INT IDENTITY PRIMARY KEY,
invoice XML(document invoice_xsd)
)
Go UPDATE STATISTICS xmlInvoice DBCC FREEPROCCACHE
-- query 1
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[@InvoiceId = "1003"]') = 1
-- query 2
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/@InvoiceId[. = "1003"]') = 1
-- query 3
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[1]/@InvoiceId[. = "1003"]') = 1
-- query 4
SELECT * FROM xmlInvoice
WHERE invoice.exist('(/Invoice/@InvoiceId)[1][. = "1003"]') = 1
-- query 5
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice[CustomerName = "Vahid"]') = 1
-- query 6
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/CustomerName [.= "Vahid"]') = 1
-- query 7
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/LineItems/LineItem[Description = "Trellis"]') = 1
-- query 8
SELECT * FROM xmlInvoice
WHERE invoice.exist('/Invoice/LineItems/LineItem/Description [.= "Trellis"]') = 1
-- query 9
SELECT * FROM xmlInvoice
WHERE invoice.exist('
for $x in /Invoice/@InvoiceId
where $x = 1003
return $x
') = 1
-- query 10
SELECT * FROM xmlInvoice
WHERE invoice.value('(/Invoice/@InvoiceId)[1]', 'VARCHAR(10)') = '1003'
-- یکبار هم با جدول شماره 2 که اسکیما دارد تمام این موارد تکرار شود
UPDATE STATISTICS xmlInvoice
DBCC FREEPROCCACHE
GO 
D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef
_/\__
---==/ \\
___ ___ |. \|\
| __|| __| | ) \\\
| _| | _| \_/ | //|\\
|___||_| / \\\/\\
Entity Framework .NET Core CLI Commands 1.0.0-preview2-21431
Usage: dotnet ef [options] [command]
Options:
-h|--help Show help information
-v|--verbose Enable verbose output
--version Show version information
--assembly <ASSEMBLY> The assembly file to load.
--startup-assembly <ASSEMBLY> The assembly file containing the startup class.
--data-dir <DIR> The folder used as the data directory (defaults to current working directory).
--project-dir <DIR> The folder used as the project directory (defaults to current working directory).
--content-root-path <DIR> The folder used as the content root path for the application (defaults to application base directory).
--root-namespace <NAMESPACE> The root namespace of the target project (defaults to the project assembly name).
Commands:
database Commands to manage your database
dbcontext Commands to manage your DbContext types
migrations Commands to manage your migrations
Use "dotnet ef [command] --help" for more information about a command. D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef migrations add InitialDatabase
D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef database update Applying migration '13950526050417_InitialDatabase'. Done.
using System.Collections.Generic;
using System.Linq;
using Core1RtmEmptyTest.Entities;
using Microsoft.Extensions.DependencyInjection;
namespace Core1RtmEmptyTest.Migrations
{
public static class ApplicationDbContextSeedData
{
public static void SeedData(this IServiceScopeFactory scopeFactory)
{
using (var serviceScope = scopeFactory.CreateScope())
{
var context = serviceScope.ServiceProvider.GetService<ApplicationDbContext>();
if (!context.Persons.Any())
{
var persons = new List<Person>
{
new Person
{
FirstName = "Admin",
LastName = "User"
}
};
context.AddRange(persons);
context.SaveChanges();
}
}
}
}
} public void Configure(IServiceScopeFactory scopeFactory)
{
scopeFactory.SeedData(); public void ConfigureServices(IServiceCollection services)
{
services.AddDbContext<ApplicationDbContext>(ServiceLifetime.Scoped); 
namespace Core1RtmEmptyTest.Entities
{
public class Person
{
public int PersonId { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int Age { get; set; }
}
} An unhandled exception occurred while processing the request. SqlException: Invalid column name 'Age'.
D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef migrations add v2 D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef database update
D:\Prog\1395\Core1RtmEmptyTest\src\Core1RtmEmptyTest>dotnet ef migrations script -o v2.sql
public Configuration()
{
AutomaticMigrationsEnabled = true;
} using Core1RtmEmptyTest.Entities;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
namespace Core1RtmEmptyTest.Migrations
{
public static class DbInitialization
{
public static void Initialize(this IServiceScopeFactory scopeFactory)
{
using (var serviceScope = scopeFactory.CreateScope())
{
var context = serviceScope.ServiceProvider.GetService<ApplicationDbContext>();
// Applies any pending migrations for the context to the database.
// Will create the database if it does not already exist.
context.Database.Migrate();
}
}
}
} بعد از اینکه مفاهیم معماریمون یکی شد، رفتیم سراغ باور‌های غلطی و یا استدلال‌های غلطی که داریم، مثل اینکه نتورک و یا سرویس خارجی همیشه سالم و درست کار میکنند. و با الگو هایی مثلا Circuit Breaker و Retry Pattern آشنا شدیم و در انتها این هارو با پکیج Polly پیاده سازی کردیم.
02:00 Fallacy 1- The Network is Reliable
05:30 Retry Pattern
06:33 Circuit Breaker Pattern
13:00 Circuit Breaker Pattern Flow
18:00 Circuit Breaker Pattern State Machin
26:00 Implement Retry and Circuit breaker pattern with Polly
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="log4net"
type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
</configSections>
<connectionStrings>
<!--NHSessionManager-->
<add name="DbConnectionString"
connectionString="Data Source=(local);Initial Catalog=HelloNHibernate;Integrated Security = true"/>
</connectionStrings>
<log4net>
<appender name="rollingFile"
type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="NHibernate_Log.txt" />
<param name="AppendToFile" value="true" />
<param name="DatePattern" value="yyyy.MM.dd" />
<rollingStyle value="Size" />
<maxSizeRollBackups value="10" />
<maximumFileSize value="500KB" />
<staticLogFileName value="true" />
<layout type="log4net.Layout.PatternLayout,log4net">
<conversionPattern value="%d %p %m%n" />
</layout>
</appender>
<logger name="NHibernate.SQL">
<level value="ALL" />
<appender-ref ref="rollingFile" />
</logger>
</log4net>
</configuration>
log4net.Config.XmlConfigurator.Configure();
// Configure log4net using the .config file
[assembly: log4net.Config.XmlConfigurator(Watch = true)]
2009-10-18 20:03:54,187 DEBUG INSERT INTO [Student] (Name) VALUES (@p0); select SCOPE_IDENTITY();@p0 = 'Vahid'
log4net.LogManager.GetLogger("NHibernate.SQL").Info("test1");
