https://localhost:5001/swagger/LibraryOpenAPISpecification/swagger.json
docker pull microsoft/mssql-server-linux:2017-latest
sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<YourStrong!Passw0rd>' \ -p 1433:1433 --name sql1 \ -d mcr.microsoft.com/mssql/server:2017-latest
Server Host: localhost Port: 1433 Authentication: SQL Server Authentication Login: SA Password: <StrongPasswordYouSet>
sudo docker exec -it sql1 "bash"
/opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P '<YourNewStrong!Passw0rd>'
CREATE DATABASE TestDB
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
SELECT Name from sys.Databases
SELECT * FROM Inventory WHERE quantity > 152;
dotnet new webapi -o dockerapi
dotnet add package Microsoft.EntityFrameworkCore.SqlServer dotnet add package Microsoft.EntityFrameworkCore.Design
public class Students
{
public int Id { get; set; }
public string Name { get; set; }
public string Phone { get; set; }
} dotnet ef dbcontext scaffold "Server=localhost,1433\\Catalog=tutorial_database;Database=<YOUR_DATABASE_NAME>;User=SA;Password=<StrongPasswordYouSet>;" Microsoft.EntityFrameworkCore.SqlServer
"ConnectionStrings": {
"TestingDatabase": "Server=localhost:1433\\Database=<YourDatabaseName>;User=SA;Password=<StrongPasswordYouSet>;"
} dotnet ef migrations add <NAME_OF_MIGRATION>
ef database update
SELECT TABLE_NAME FROM dockerdb.INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'
namespace DI04.Services
{
public interface IAccounting
{
void CreateInvoice(int orderId, int count);
}
}
namespace DI04.Services
{
public interface ISales
{
bool ShippingAllowed(int orderId);
}
}
namespace DI04.Services
{
public interface IOrderHandler
{
void Handle(int orderId, int count);
}
}
using System;
namespace DI04.Services
{
public class Accounting : IAccounting
{
public Accounting()
{
Console.WriteLine("Accounting ctor.");
}
public void CreateInvoice(int orderId, int count)
{
// ...
}
}
}
using System;
namespace DI04.Services
{
public class Sales : ISales
{
public Sales()
{
Console.WriteLine("Sales ctor.");
}
public bool ShippingAllowed(int orderId)
{
// فقط جهت آزمایش سیستم
return false;
}
}
}
using System;
namespace DI04.Services
{
public class OrderHandler : IOrderHandler
{
private readonly IAccounting _accounting;
private readonly ISales _sales;
public OrderHandler(IAccounting accounting, ISales sales)
{
Console.WriteLine("OrderHandler ctor.");
_accounting = accounting;
_sales = sales;
}
public void Handle(int orderId, int count)
{
if (_sales.ShippingAllowed(orderId))
{
_accounting.CreateInvoice(orderId, count);
}
}
}
}private readonly Lazy<IAccounting> _accounting;
using System;
namespace DI04.Services
{
public class OrderHandlerLazy : IOrderHandler
{
private readonly Lazy<IAccounting> _accounting;
private readonly Lazy<ISales> _sales;
public OrderHandlerLazy(Lazy<IAccounting> accounting, Lazy<ISales> sales)
{
Console.WriteLine("OrderHandlerLazy ctor.");
_accounting = accounting;
_sales = sales;
}
public void Handle(int orderId, int count)
{
if (_sales.Value.ShippingAllowed(orderId))
{
_accounting.Value.CreateInvoice(orderId, count);
}
}
}
}using System;
using DI04.Services;
using StructureMap;
namespace DI04
{
class Program
{
static void Main(string[] args)
{
// تنظیمات اولیه برنامه که فقط یکبار باید در طول عمر برنامه انجام شود
ObjectFactory.Initialize(x =>
{
x.For<IOrderHandler>().Use<OrderHandlerLazy>();
// Lazy loading
x.For<Lazy<IAccounting>>().Use(c => new Lazy<IAccounting>(c.GetInstance<Accounting>));
x.For<Lazy<ISales>>().Use(c => new Lazy<ISales>(c.GetInstance<Sales>));
});
var orderHandler = ObjectFactory.GetInstance<IOrderHandler>();
orderHandler.Handle(orderId: 1, count: 10);
}
}
}OrderHandlerLazy ctor. Sales ctor.
<AuthorizeView>
<Authorized>
<a href="Identity/Account/Logout">Logout</a>
</Authorized>
<NotAuthorized>
<a href="Identity/Account/Register">Register</a>
<a href="Identity/Account/Login">Login</a>
</NotAuthorized>
</AuthorizeView> InvalidOperationException: Authorization requires a cascading parameter of type Task<AuthenticationState>. Consider using CascadingAuthenticationState to supply this. Microsoft.AspNetCore.Components.Authorization.AuthorizeViewCore.OnParametersSetAsync()
<CascadingAuthenticationState>
<Router AppAssembly="@typeof(Program).Assembly" PreferExactMatches="@true">
<Found Context="routeData">
<RouteView RouteData="@routeData" DefaultLayout="@typeof(MainLayout)" />
</Found>
<NotFound>
<LayoutView Layout="@typeof(MainLayout)">
<p>Sorry, there's nothing at this address.</p>
</LayoutView>
</NotFound>
</Router>
</CascadingAuthenticationState> 
@page
@using Microsoft.AspNetCore.Identity
@inject SignInManager<IdentityUser> SignInManager
@functions
{
public async Task<IActionResult> OnGet()
{
if (SignInManager.IsSignedIn(User))
{
<p>You have successfully logged out of the application.</p>
await SignInManager.SignOutAsync();
}
return Redirect("~/");
}
} <AuthorizeView>
<Authorized>
Hello, @context.User.Identity.Name
<a href="Identity/Account/Logout">Logout</a>
</Authorized> 
@attribute [Authorize]
<CascadingAuthenticationState>
<Router AppAssembly="@typeof(Program).Assembly" PreferExactMatches="@true">
<Found Context="routeData">
@*<RouteView RouteData="@routeData" DefaultLayout="@typeof(MainLayout)" />*@
<AuthorizeRouteView RouteData="@routeData" DefaultLayout="@typeof(MainLayout)">
<NotAuthorized>
<p>Sorry, you do not have access to this page</p>
</NotAuthorized>
</AuthorizeRouteView>
</Found>
<NotFound>
<LayoutView Layout="@typeof(MainLayout)">
<p>Sorry, there's nothing at this address.</p>
</LayoutView>
</NotFound>
</Router>
</CascadingAuthenticationState> 
@Html.ActionLink("About us", "Index", "About")
<a href="/About">About us</a>
@using MvcApplication5.Models
@model MvcApplication5.Models.Products
@{
ViewBag.Title = "Index";
}
@helper GetProductsList(List<Product> products)
{
<ul>
@foreach (var item in products)
{
<li>@Html.ActionLink(item.Name, "Details", new { id = item.ProductNumber })</li>
}
</ul>
}
<h2>Index</h2>
@GetProductsList(@Model)
http://localhost/Home/Details/D123
using System.Linq;
using System.Web.Mvc;
using MvcApplication5.Models;
namespace MvcApplication5.Controllers
{
public class HomeController : Controller
{
public ActionResult Index()
{
var products = new Products();
return View(products);
}
public ActionResult Details(string id)
{
var product = new Products().FirstOrDefault(x => x.ProductNumber == id);
if (product == null)
return View("Error");
return View(product);
}
}
}
@model MvcApplication5.Models.Product
@{
ViewBag.Title = "Details";
}
<h2>Details</h2>
<fieldset>
<legend>Product</legend>
<div class="display-label">ProductNumber</div>
<div class="display-field">@Model.ProductNumber</div>
<div class="display-label">Name</div>
<div class="display-field">@Model.Name</div>
<div class="display-label">Price</div>
<div class="display-field">@String.Format("{0:F}", Model.Price)</div>
</fieldset>
<p>
@Html.ActionLink("Edit", "Edit", new { /* id=Model.PrimaryKey */ }) |
@Html.ActionLink("Back to List", "Index")
</p>
'System.Web.WebPages.Html.HtmlHelper' does not contain a definition for 'ActionLink'
@using System.Web.Mvc
@using System.Web.Mvc.Html
@using MvcApplication5.Models
@helper GetProductsList(WebViewPage page, List<Product> products)
{
<ul>
@foreach (var item in products)
{
<li> @page.Html.ActionLink(item.Name, "Details", new { id = item.ProductNumber })</li>
}
</ul>
}
@MyHelpers.GetProductsList(this, @Model)
http://localhost/Home/Details/%D9%85%D9%82%D8%AF%D8%A7%D8%B1%20%D9%8A%D9%83
<li><a href="/Home/Details/مقدار یک">Super Fast Bike</a></li>
@helper EmitCleanUnicodeUrl(MvcHtmlString data)
{
@Html.Raw(HttpUtility.UrlDecode(data.ToString()))
}
@helper GetProductsList(List<Product> products)
{
<ul>
@foreach (var item in products)
{
<li>@EmitCleanUnicodeUrl(@Html.ActionLink(item.Name, "Details", new { id = item.ProductNumber }))</li>
}
</ul>
}
dependencies {
compile 'com.michaelpardo:activeandroid:3.1.0-SNAPSHOT'
} allprojects {
repositories {
jcenter()
}
} allprojects {
repositories {
mavenCentral()
}
} //project build.gradle
repositories {
maven { url 'https://maven.fabric.io/public' }
}
//module build.gradle
dependencies {
compile 'com.crashlytics.sdk.android:crashlytics:2.2.4@aar'
} GROUP_ID:ARTIFACT_ID:VERSION
dependencies {
compile 'com.squareup:otto:1.3.7'
compile 'com.squareup.picasso:picasso:2.5.2'
compile 'com.squareup.okhttp:okhttp:2.4.0'
compile 'com.squareup.retrofit:retrofit:1.9.0'
} - /AndroidManifest.xml (الزامی) - /classes.jar (الزامی ) - /res/ (الزامی ) - /R.txt (الزامی ) - /assets/ (اختیاری) - /libs/*.jar (اختیاری ) - /jni/<abi>/*.so (اختیاری ) - /proguard.txt (اختیاری ) - /lint.jar (اختیاری )
این افزونه تعدادی از بهترین افزونه‌های +Angular 2 را به صورت خودکار و یکجا نصب می‌کند.
سپاس از شما
8.ORM Lazy Load
List<Customer> customers = context.Customers.ToList();
foreach (Customer cust in context.Customers){
Console.WriteLine("Customer {0}, Account {1}", cust.Person.LastName.Trim() + ", " + cust.Person.FirstName, cust.AccountNumber);
}9.استفاده از MiniProfiler
#if DEBUG then // فعال سازی MiniProfiler #endif
10. Data Paging در بانک اطلاعاتی
11. بررسی تعداد کوئری‌های صادر شده در یک صفحه و تعداد رکوردهای بازگشت داده شده توسط آن‌ها