LINQ ááẠ.NET á¡á¬áž á¡á
áœááºážáááºáá±á¬ áá±áá¬ááŒááºááŸááºááŸá¯áá¬áá¬á
áá¬ážá¡áá
áºáá
áºáá¯á¡ááŒá
Ạááá·áºááœááºážáá²á·áááºá áááºážááá
áºá
áááºáá
áºááá¯ááºážá¡áá±ááŒáá·áº LINQ á០SQL ááẠá¥ááá¬á¡á¬ážááŒáá·áº Entity Framework ááᯠá¡áá¯á¶ážááŒá¯á DBMS ááŸáá·áº á¡áá±á¬áºáá±áž á¡áááºááŒá±á
áœá¬ áááºááœááºááá¯ááºá
á±áá«áááºá ááá¯á·áá±á¬áºá áááºážááá¯áááŒá¬ááá¡áá¯á¶ážááŒá¯ááŒááºážááŒáá·áº developer áá»á¬ážááẠááá·áºááá
á¹á
ááœáẠEntity Framework ááẠqueryable provider á០SQL query á¡áá»áá¯ážá¡á
á¬ážááá¯ááŒáá·áºááŸá¯áááºáá±á·áá»á±á¬á·áá±áá«áááºá
á¥ááá¬áá
áºáá¯áá¯á¶ážááŒá®áž á¡ááá á¡áá»ááºááŸá
áºáá»ááºááᯠááŒáá·áºááŒáá¡á±á¬ááºá
áááºážááá¯áá¯ááºáá±á¬ááºáááºá SQL Server ááœáẠTest database áá
áºáá¯ááá¯áááºáá®ážááŒá®áž á¡á±á¬ááºáá«áá±ážááœááºážááá¯á¡áá¯á¶ážááŒá¯á áááºážááœááºááá¬ážááŸá
áºáá¯áááºáá®ážáá«á
ááá¬ážáá»á¬ážáááºáá®ážááŒááºážá
USE [TEST]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ref](
[ID] [int] NOT NULL,
[ID2] [int] NOT NULL,
[Name] [nvarchar](255) NOT NULL,
[InsertUTCDate] [datetime] NOT NULL,
CONSTRAINT [PK_Ref] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Ref] ADD CONSTRAINT [DF_Ref_InsertUTCDate] DEFAULT (getutcdate()) FOR [InsertUTCDate]
GO
USE [TEST]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
[ID] [int] NOT NULL,
[Name] [nvarchar](255) NOT NULL,
[Ref_ID] [int] NOT NULL,
[InsertUTCDate] [datetime] NOT NULL,
[Ref_ID2] [int] NOT NULL,
CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_Ref_ID] DEFAULT ((0)) FOR [Ref_ID]
GO
ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_InsertUTCDate] DEFAULT (getutcdate()) FOR [InsertUTCDate]
GO
ááᯠá¡á±á¬ááºáá« script ááᯠrun ááŒááºážááŒáá·áº Ref table ááᯠááŒáá·áºááŒáá«á áá¯á·á
Ref table ááá¯ááŒáá·áºáá«á
USE [TEST]
GO
DECLARE @ind INT=1;
WHILE(@ind<1200000)
BEGIN
INSERT INTO [dbo].[Ref]
([ID]
,[ID2]
,[Name])
SELECT
@ind
,@ind
,CAST(@ind AS NVARCHAR(255));
SET @ind=@ind+1;
END
GO
á¡á±á¬ááºáá±á¬áºááŒáá« script ááá¯á¡áá¯á¶ážááŒá¯á áááºáá°áá°ááá¬ážááᯠá¡áá¬ážáá°ááŒáá·áºá áœááºááŒáá«á áá¯á·á
áá±á¬ááºáááºááá¬ážááᯠááŒáá·áºááœááºážááŒááºážá
USE [TEST]
GO
DECLARE @ind INT=1;
DECLARE @ind_ref INT=1;
WHILE(@ind<=12000000)
BEGIN
IF(@ind%3=0) SET @ind_ref=1;
ELSE IF (@ind%5=0) SET @ind_ref=2;
ELSE IF (@ind%7=0) SET @ind_ref=3;
ELSE IF (@ind%11=0) SET @ind_ref=4;
ELSE IF (@ind%13=0) SET @ind_ref=5;
ELSE IF (@ind%17=0) SET @ind_ref=6;
ELSE IF (@ind%19=0) SET @ind_ref=7;
ELSE IF (@ind%23=0) SET @ind_ref=8;
ELSE IF (@ind%29=0) SET @ind_ref=9;
ELSE IF (@ind%31=0) SET @ind_ref=10;
ELSE IF (@ind%37=0) SET @ind_ref=11;
ELSE SET @ind_ref=@ind%1190000;
INSERT INTO [dbo].[Customer]
([ID]
,[Name]
,[Ref_ID]
,[Ref_ID2])
SELECT
@ind,
CAST(@ind AS NVARCHAR(255)),
@ind_ref,
@ind_ref;
SET @ind=@ind+1;
END
GO
ááá¯á·ááŒá±á¬áá·áºá ááá¬ážááŸá áºáá¯ááᯠáááºáá¶áááŸááá²á·ááŒá®áž áá áºáá¯ááẠáá±áá¬á¡áááºážáá±á«ááºáž 1 áááºážáá»á±á¬áºááŸáááŒá®áž á¡ááŒá¬ážáá áºáá¯ááẠáá±áá¬á¡áááºáž 10 áááºážáá»á±á¬áºááŸááááºá
ááᯠVisual Studio ááœáẠVisual C# Console App (.NET Framework) ááá±á¬áá»ááºááᯠá ááºážáááºáááºáá®ážááẠááá¯á¡ááºáááº-
ááá¯á·áá±á¬ááºá áááºááẠáá±áá¬áá±á·á
áºááŸáá·áº á¡ááŒááºá¡ááŸááºáá¯á¶á·ááŒááºááẠEntity Framework á¡ááœáẠá
á¬ááŒáá·áºááá¯ááºáá
áºáá¯ááᯠááá·áºáááºááá¯á¡ááºáááºá
áááºážááá¯ááá·áºáááºá ááá±á¬áá»ááºáá±á«áºááœáẠright-click ááŸáááºááŒá®áž context menu á០Manage NuGet Packages ááá¯ááœá±ážáá»ááºáá«á
ááá¯á·áá±á¬ááºáá±á«áºáá¬áá±á¬ NuGet áááºáá±á·áá»áºá
á®áá¶ááá·áºááœá²ááŸá¯áááºážááá¯ážááœááºá ááŸá¬ááœá±áá±ážáááºážááá¯ážááœáẠ"Entity Framework" áá°áá±á¬á
áá¬ážáá¯á¶ážááá¯ááá¯ááºááá·áºáᬠEntity Framework áááºáá±á·áá»áºááá¯ááœá±ážáá»ááºááŒá®áž áááºážááá¯ááá·áºááœááºážáá«á
ááá¯á·áá±á¬ááºá App.config ááá¯ááºááœáẠconfigSections ááŒááºá
ááºááá¯ááááºááŒá®ážáá±á¬ááºá áááºááẠá¡á±á¬ááºáá«ááá±á¬ááºááᯠááá·áºááẠááá¯á¡ááºáááº-
<connectionStrings>
<add name="DBConnection" connectionString="data source=ÐÐЯ_ÐÐÐÐÐÐÐЯРÐ_MSSQL;Initial Catalog=TEST;Integrated Security=True;" providerName="System.Data.SqlClient" />
</connectionStrings>
connectionString ááœáẠáááºááẠconnection string ááá¯ááá¯ááºááá·áºááẠááá¯á¡ááºáááºá
ááᯠáá®ážááŒá¬ážááá¯ááºáá»á¬ážááœáẠá¡ááºáá¬áá±á·á Ạ3 áᯠáááºáá®ážááŒáá«á áá¯á·á
- IBaseEntityID á¡ááºáá¬áá±á·á
áºááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
namespace TestLINQ { public interface IBaseEntityID { int ID { get; set; } } }
- IBaseEntityName á¡ááºáá¬áá±á·á
áºááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
namespace TestLINQ { public interface IBaseEntityName { string Name { get; set; } } }
- IBaseNameInsertUTCDate á¡ááºáá¬áá±á·á
áºááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
namespace TestLINQ { public interface IBaseNameInsertUTCDate { DateTime InsertUTCDate { get; set; } } }
áá®ážááŒá¬ážááá¯ááºáá áºáá¯ááœáẠáá»áœááºá¯ááºááá¯á·ááẠáá¯á¶áááºáááºáá»á¬ážáá«áááºááá·áº áá»áœááºá¯ááºááá¯á·áá¡ááœá²á·á¡á ááºážááŸá áºáá¯á¡ááœáẠá¡ááŒá±áá¶áá°áááºážá á¬áž BaseEntity áá áºáá¯ááᯠáááºáá®ážáá«áááºá
á¡ááŒá±áá¶áá°áááºážá á¬áž BaseEntity ááá¯á¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
namespace TestLINQ
{
public class BaseEntity : IBaseEntityID, IBaseEntityName, IBaseNameInsertUTCDate
{
public int ID { get; set; }
public string Name { get; set; }
public DateTime InsertUTCDate { get; set; }
}
}
ááá¯á·áá±á¬ááºá áá»áœááºá¯ááºááá¯á·ááẠáá®ážááŒá¬ážááá¯ááºáá»á¬ážááœáẠáá»áœááºá¯ááºááá¯á·áá¡áá¬ááŸá áºáá¯ááᯠáááºáá®ážáá«áááºá
- Ref class ááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
using System.ComponentModel.DataAnnotations.Schema; namespace TestLINQ { [Table("Ref")] public class Ref : BaseEntity { public int ID2 { get; set; } } }
- Customer class ááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
using System.ComponentModel.DataAnnotations.Schema; namespace TestLINQ { [Table("Customer")] public class Customer: BaseEntity { public int Ref_ID { get; set; } public int Ref_ID2 { get; set; } } }
ááᯠáá®ážááŒá¬ážááá¯ááºáá áºáá¯ááœáẠUserContext á¡ááŒá±á¬ááºážá¡áá¬áá áºáá¯ááᯠáááºáá®ážááŒáá«á áá¯á·á
UserContex á¡áááºážááᯠá¡áá±á¬ááºá¡áááºáá±á¬áºááŒááºážá
using System.Data.Entity;
namespace TestLINQ
{
public class UserContext : DbContext
{
public UserContext()
: base("DbConnection")
{
Database.SetInitializer<UserContext>(null);
}
public DbSet<Customer> Customer { get; set; }
public DbSet<Ref> Ref { get; set; }
}
}
MS SQL Server á¡ááœáẠEF ááŸáááá·áº LINQ ááŸáá·áº SQL á០ááá¯ááá¯áá±á¬ááºážááœááºá¡á±á¬ááºáá¯ááºáá±á¬ááºááŒááºážá¡ááœáẠá¡áááºááá·áºáá¯ááºáá¬ážáá±á¬ ááŒá±ááŸááºážáá»ááºáá áºáá¯ááᯠáááºáá¶áááŸááááº-
ááᯠProgram.cs ááá¯ááºáá²ááá¯á· á¡á±á¬ááºáá«áá¯ááºááᯠááá·áºáá«á
Program.cs ááá¯ááº
using System;
using System.Collections.Generic;
using System.Linq;
namespace TestLINQ
{
class Program
{
static void Main(string[] args)
{
using (UserContext db = new UserContext())
{
var dblog = new List<string>();
db.Database.Log = dblog.Add;
var query = from e1 in db.Customer
from e2 in db.Ref
where (e1.Ref_ID == e2.ID)
&& (e1.Ref_ID2 == e2.ID2)
select new { Data1 = e1.Name, Data2 = e2.Name };
var result = query.Take(1000).ToList();
Console.WriteLine(dblog[1]);
Console.ReadKey();
}
}
}
}
ááá¯á·áá±á¬áẠáá»áœááºá¯ááºááá¯á·á ááá±á¬áá»ááºááᯠá áááºááŒáá«á áá¯á·á
á¡áá¯ááºáá¡áá¯á¶ážááœááºá console ááœááºá¡á±á¬ááºáá«ááá¯á·ááá¯ááŒááááá·áºáááº-
SQL Query ááá¯áá¯ááºáá±ážáááºá
SELECT TOP (1000)
[Extent1].[Ref_ID] AS [Ref_ID],
[Extent1].[Name] AS [Name],
[Extent2].[Name] AS [Name1]
FROM [dbo].[Customer] AS [Extent1]
INNER JOIN [dbo].[Ref] AS [Extent2] ON ([Extent1].[Ref_ID] = [Extent2].[ID]) AND ([Extent1].[Ref_ID2] = [Extent2].[ID2])
ááá¯ááá¯áááºááŸá¬ áá±áá°áá»á¡á¬ážááŒáá·áº LINQ query ááẠMS SQL Server DBMS ááá¯á· SQL query ááá¯áá¯ááºáá±ážáááºá
ááᯠLINQ áá±ážááŒááºážááŸá¯ááœáẠAND á¡ááŒá±á¡áá±á¡á¬áž OR ááá¯á· ááŒá±á¬ááºážááŒáá«á áá¯á·á
LINQ áá±ážááŒááºážááŸá¯
var query = from e1 in db.Customer
from e2 in db.Ref
where (e1.Ref_ID == e2.ID)
|| (e1.Ref_ID2 == e2.ID2)
select new { Data1 = e1.Name, Data2 = e2.Name };
ááŒá®ážáá±á¬á· áá«ááá¯á·áá²á· áá»áŸá±á¬ááºááœáŸá¬ááᯠááŒááºááœáá·áºááŒáá·áºáá¡á±á¬ááºá
30 á áá¹ááá·áºáááºáá»á±á¬áºááœááºáá±á¬ command execute á¡áá»áááºááŒá±á¬áá·áº áá¯ááºáá±á¬ááºáá»ááºááẠá¡ááŸá¬ážá¡ááœááºážáá áºáá¯ááŸáá·áº áá»ááºááœá¬ážáááá·áºáááº-
LINQ ááŸáá¯ááºáá±ážáá±á¬áá±ážááœááºážááá¯ááŒáá·áºáá»áŸááº-
ááá¯á·áá±á¬áẠááœá±ážáá»ááºááŸá¯ááẠááŸá
áºá
á¯á¶ (ááá¬ážáá»á¬áž) á Cartesian áá¯ááºáá¯ááºááŸáá
áºááá·áº ááŒá
áºáá±á«áºáá¬ááŒá±á¬ááºáž áá±áá»á¬á
á±ááá¯ááºáá«áááºá
SQL Query ááá¯áá¯ááºáá±ážáááºá
SELECT TOP (1000)
[Extent1].[Ref_ID] AS [Ref_ID],
[Extent1].[Name] AS [Name],
[Extent2].[Name] AS [Name1]
FROM [dbo].[Customer] AS [Extent1]
CROSS JOIN [dbo].[Ref] AS [Extent2]
WHERE [Extent1].[Ref_ID] = [Extent2].[ID] OR [Extent1].[Ref_ID2] = [Extent2].[ID2]
LINQ áá±ážááœááºážááᯠá¡á±á¬ááºáá«á¡ááá¯ááºáž ááŒááºáá±ážááŒáá«á áá¯á·á
ááá¯ááá¯áá±á¬ááºážááœááºáá±á¬ LINQ áá±ážááŒááºážááŸá¯
var query = (from e1 in db.Customer
join e2 in db.Ref
on e1.Ref_ID equals e2.ID
select new { Data1 = e1.Name, Data2 = e2.Name }).Union(
from e1 in db.Customer
join e2 in db.Ref
on e1.Ref_ID2 equals e2.ID2
select new { Data1 = e1.Name, Data2 = e2.Name });
ááá¯á·áá±á¬áẠá¡á±á¬ááºáá« SQL query ááᯠáá»áœááºá¯ááºááá¯á· áááŸáááẠá
SQL áá±ážááŒááºážááŸá¯
SELECT
[Limit1].[C1] AS [C1],
[Limit1].[C2] AS [C2],
[Limit1].[C3] AS [C3]
FROM ( SELECT DISTINCT TOP (1000)
[UnionAll1].[C1] AS [C1],
[UnionAll1].[Name] AS [C2],
[UnionAll1].[Name1] AS [C3]
FROM (SELECT
1 AS [C1],
[Extent1].[Name] AS [Name],
[Extent2].[Name] AS [Name1]
FROM [dbo].[Customer] AS [Extent1]
INNER JOIN [dbo].[Ref] AS [Extent2] ON [Extent1].[Ref_ID] = [Extent2].[ID]
UNION ALL
SELECT
1 AS [C1],
[Extent3].[Name] AS [Name],
[Extent4].[Name] AS [Name1]
FROM [dbo].[Customer] AS [Extent3]
INNER JOIN [dbo].[Ref] AS [Extent4] ON [Extent3].[Ref_ID2] = [Extent4].[ID2]) AS [UnionAll1]
) AS [Limit1]
Alasá LINQ queries ááœáẠJoin condition áá
áºáá¯áá¬ááŸáááá¯ááºáááºá ááá¯á·ááŒá±á¬áá·áº á€áá±áá¬ááœáẠá¡ááŒá±á¡áá±áá
áºáá¯á
á®á¡ááœáẠqueries ááŸá
áºáá¯ááᯠá¡áá¯á¶ážááŒá¯á áá®áá»áŸáá±á¬ query áá
áºáá¯ááŒá¯áá¯ááºááá¯ááºááŒá®áž á¡áááºážáá»á¬ážááŒá¬ážá០áááºáá±áá±á¬áá»á¬ážááá¯áááºááŸá¬ážáááºá¡ááœáẠUnion ááŸáá
áºááá·áº áááºážááá¯á·ááᯠáá±á«ááºážá
ááºááá¯ááºáá«á
áá¯ááºáá²á·á ááŒá®ážááŒáá·áºá
á¯á¶áá±á¬ á¡áááºážáá»á¬ážááᯠááŒááºáá±ážáááºááᯠááá·áºááœááºážá
ááºážá
á¬ážááŒááºážááŒáá·áº áá±ážááœááºážáá»á¬ážááẠáá±áá°áá»á¡á¬ážááŒáá·áº áá°áá®áááºááá¯ááºáá«á ááá¯á·áá±á¬áºá áááºááœá±á·ááááœááºá ááŒá®ážááŒáá·áºá
á¯á¶áá±á¬ áááºáá°ááá¯ááºážáá»á¬ážááᯠáááá¯á¡ááºáá² áá°áá»á¬ážá áááºážááá¯á·ááᯠáááºááŸá¬ážááẠááŒáá¯ážá
á¬ážááŒáááºá
ááᯠá€áá±ážááœááºážááŸá áºáá¯á á¡áá±á¬ááºá¡áááºáá±á¬áºááŸá¯á¡á á®á¡á ááºááᯠááŸáá¯ááºážááŸááºááŒáá·áºáá¡á±á¬ááºá
- CROSS JOIN á¡ááœáẠáá»ááºážáá»áŸáá¯ááºáá±á¬ááºáá»áááºááẠ195 á
áá¹ááá·áºááŒá
áºáááºá
- Inner JOIN-UNION á¡ááœáẠáá»ááºážáá»áŸáá¯ááºáá±á¬ááºáá»áááºááẠ24 á
áá¹ááá·áºáááºáááºážáááº-
ááááºáá»á¬ážá០áááºááœá±á·ááŒááºáááá·áºá¡ááá¯ááºážá ááŸááºáááºážáá±á«ááºáž áááºážááŸáá·áºáá»á®ááŸááá±á¬ ááá¬ážááŸá áºáá¯á¡ááœááºá á¡áá±á¬ááºážáá¯á¶ážááŒááºáááºáá¬ážáá±á¬ LINQ áá±ážááœááºážááẠááŒá¯ááŒááºááá¬ážááá·áºá¡áá¬ááẠá¡ááá»á¬ážá áœá¬ ááá¯ááŒááºáá«áááºá
á¡ááŒá±á¡áá±áá»á¬ážááœáẠAND áá«áá±á¬ ááœá±ážá áá¬á¡ááœááºá áá±á¬ááºá LINQ áá±ážááŒááºážáá»ááºáá áºáá¯-
LINQ áá±ážááŒááºážááŸá¯
var query = from e1 in db.Customer
from e2 in db.Ref
where (e1.Ref_ID == e2.ID)
&& (e1.Ref_ID2 == e2.ID2)
select new { Data1 = e1.Name, Data2 = e2.Name };
ááŸááºáááºáá±á¬ SQL query ááᯠá¡ááŒá²áááºážáá®ážáá«ážáá¯ááºáá±ážáááºááŒá áºááŒá®ážá áááºážááẠáá»ááºážáá»áŸá¡á¬ážááŒáá·áº 1 á áá¹ááá·áºááá·áºá¡ááœááºáž áá¯ááºáá±á¬ááºááá¯ááºáááº-
á¡áá¬ážáá° query á¡á
á¬áž LINQ to Objects á០ááŒááºááŸááºááŒááºážáá»á¬ážá¡ááœááºáááºáž
LINQ áá±ážááŒááºážááŸá¯ (áááááœá±ážáá»ááºááŸá¯)
var query = from e1 in seq1
from e2 in seq2
where (e1.Key1==e2.Key1)
&& (e1.Key2==e2.Key2)
select new { Data1 = e1.Data, Data2 = e2.Data };
áááºáá²á·ááá¯á·áá±á¬áá±ážááœááºážááá¯áá¯á¶ážááá¯ááºáááºá
LINQ áá±ážááŒááºážááŸá¯ (áááááœá±ážáá»ááºááŸá¯)
var query = from e1 in seq1
join e2 in seq2
on new { e1.Key1, e1.Key2 } equals new { e2.Key1, e2.Key2 }
select new { Data1 = e1.Data, Data2 = e2.Data };
áááºááŸá¬:
Array ááŸá áºáá¯ááᯠáááºááŸááºááŒááºážá
Para[] seq1 = new[] { new Para { Key1 = 1, Key2 = 2, Data = "777" }, new Para { Key1 = 2, Key2 = 3, Data = "888" }, new Para { Key1 = 3, Key2 = 4, Data = "999" } };
Para[] seq2 = new[] { new Para { Key1 = 1, Key2 = 2, Data = "777" }, new Para { Key1 = 2, Key2 = 3, Data = "888" }, new Para { Key1 = 3, Key2 = 5, Data = "999" } };
Para á¡áá»áá¯ážá¡á á¬ážááᯠá¡á±á¬ááºáá«á¡ááá¯ááºáž áááºááŸááºáááºá
Para Type á¡áááá¹áá«ááº
class Para
{
public int Key1, Key2;
public string Data;
}
ááá¯á·ááŒá±á¬áá·áºá áá»áœááºá¯ááºááá¯á·ááẠMS SQL Server ááá¯á· LINQ queries áá»á¬ážááᯠá¡áá±á¬ááºážáá¯á¶ážááŒá áºá¡á±á¬áẠáá¯ááºáá±á¬ááºáá¬ááœáẠá¡áá»áá¯á·áá±á¬ ááá¹ááá»á¬ážááᯠáá±á·áá¬áá²á·áááºá
áá¶ááá±á¬ááºážá áœá¬ááŒáá·áºá á¡ááœá±á·á¡ááŒá¯á¶ááŸáááŒá®áž áŠážáá±á¬ááºáá±á¬ .NET developer áá»á¬ážááẠáá±á¬ááºááœááºááœáẠáá°ááá¯á·á¡áá¯á¶ážááŒá¯ááá·áº ááœáŸááºááŒá¬ážáá»ááºáá»á¬ážááᯠáá¬ážáááºááẠááá¯á¡ááºááŒá±á¬ááºáž áá±á·áá»á±á¬á·áá±áá«áááºá ááá¯ááºáá«áá áááºážááá¯á·ááẠáá±á¬á·ááºáá²ááºááŒá±ááŸááºážáá»ááºááᯠáá»á²á·ááœááºááŒááºážááŸáá·áº ááŒááºááááºáááºážáá»ááºá¡ááŒá±á¡áá±áá»á¬ážááœáẠá¡áá±ážá á¬ážááŒá±á¬ááºážáá²ááŸá¯áá»á¬ážááŸáá·áºá¡áá° á¡áá¬áááºááœáẠáá»áááºááá¯ááºáá¯á¶ážáá áºáá¯á¶ážááᯠáááºáááºááá¯ááºáááºá
á¡ááá¯áá»á¯á¶ážáá¯á¶ážáááºáá»ááºááá¯áááºáž áá±á¬ááºááœááºáá²á·áá«áááºá
á
ááºážáááºááŸá¯á¡ááœáẠá¡áááºážá¡ááŒá
áºáá»á¬áž - ááá±á¬áá»ááºááá¯ááºááá¯ááºá TEST áá±áá¬áá±á·á
áºááœáẠááá¬ážáá»á¬ážáááºáá®ážááŒááºážááŸáá·áº á€ááá¬ážáá»á¬ážááᯠáá±áá¬ááŒáá·áºááœááºážááŒááºážáá»á¬áž áááºááŸááááº
á€ááááºážáááºážááŸá¯ááœááºá Plans ááá¯ááºááœá²ááœááºá OR á¡ááŒá±á¡áá±áá»á¬ážááŒáá·áº áá±ážááŒááºážááŸá¯áá»á¬ážááᯠáá¯ááºáá±á¬ááºááẠá¡á
á®á¡á
ááºáá»á¬ážááŸááá«áááºá
source: www.habr.com