{"id":36156,"date":"2019-10-31T22:09:53","date_gmt":"2019-10-31T19:09:53","guid":{"rendered":"https:\/\/prohoster.info\/blog\/nekotorye-aspekty-optimizatsii-linq-zaprosov-v-c-net-dlya-ms-sql-server\/"},"modified":"2019-10-31T22:09:53","modified_gmt":"2019-10-31T19:09:53","slug":"nekotorye-aspekty-optimizatsii-linq-zaprosov-v-c-net-dlya-ms-sql-server","status":"publish","type":"post","link":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/nekotorye-aspekty-optimizatsii-linq-zaprosov-v-c-net-dlya-ms-sql-server","title":{"rendered":"Einige Aspekte der Optimierung von LINQ-Abfragen in C#.NET f\u00fcr MS SQL Server","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

LINQ \u0432\u043e\u0448\u0435\u043b \u0432 .NET \u043a\u0430\u043a \u043d\u043e\u0432\u044b\u0439 \u043c\u043e\u0449\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0438 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. LINQ to SQL \u043a\u0430\u043a \u0447\u0430\u0441\u0442\u044c \u0435\u0433\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0443\u0434\u043e\u0431\u043d\u043e \u043e\u0431\u0449\u0430\u0442\u044c\u0441\u044f \u0441 \u0421\u0423\u0411\u0414 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 Entity Framework. \u041e\u0434\u043d\u0430\u043a\u043e, \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044f \u0435\u0433\u043e, \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u0437\u0430\u0431\u044b\u0432\u0430\u044e\u0442 \u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0430 \u0442\u043e, \u043a\u0430\u043a\u043e\u0439 \u0438\u043c\u0435\u043d\u043d\u043e SQL-\u0437\u0430\u043f\u0440\u043e\u0441 \u0431\u0443\u0434\u0435\u0442 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c queryable provider, \u0432 \u0432\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u2014 Entity Framework.
\n<\/a><\/noindex>
\n\u0420\u0430\u0437\u0431\u0435\u0440\u0435\u043c \u0434\u0432\u0430 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 \u043d\u0430 \u043f\u0440\u0438\u043c\u0435\u0440\u0435.
\n\u0414\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0432 SQL Server \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 Test, \u0430 \u0432 \u043d\u0435\u0439 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0434\u0432\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430:<\/p>\n

\u0421\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446<\/b><\/p>\n

USE [TEST]\nGO\n\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\nCREATE TABLE [dbo].[Ref](\n\t[ID] [int] NOT NULL,\n\t[ID2] [int] NOT NULL,\n\t[Name] [nvarchar](255) NOT NULL,\n\t[InsertUTCDate] [datetime] NOT NULL,\n CONSTRAINT [PK_Ref] PRIMARY KEY CLUSTERED \n(\n\t[ID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]\nGO\n\nALTER TABLE [dbo].[Ref] ADD  CONSTRAINT [DF_Ref_InsertUTCDate]  DEFAULT (getutcdate()) FOR [InsertUTCDate]\nGO\n\nUSE [TEST]\nGO\n\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\nCREATE TABLE [dbo].[Customer](\n\t[ID] [int] NOT NULL,\n\t[Name] [nvarchar](255) NOT NULL,\n\t[Ref_ID] [int] NOT NULL,\n\t[InsertUTCDate] [datetime] NOT NULL,\n\t[Ref_ID2] [int] NOT NULL,\n CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED \n(\n\t[ID] ASC\n)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]\n) ON [PRIMARY]\nGO\n\nALTER TABLE [dbo].[Customer] ADD  CONSTRAINT [DF_Customer_Ref_ID]  DEFAULT ((0)) FOR [Ref_ID]\nGO\n\nALTER TABLE [dbo].[Customer] ADD  CONSTRAINT [DF_Customer_InsertUTCDate]  DEFAULT (getutcdate()) FOR [InsertUTCDate]\nGO\n<\/code><\/pre>\n
\u0422\u0435\u043f\u0435\u0440\u044c \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Ref \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0437\u0430\u043f\u0443\u0441\u043a\u0430 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u0441\u043a\u0440\u0438\u043f\u0442\u0430:<\/p>\n
\u0417\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b Ref<\/b><\/p>\n
USE [TEST]\nGO\n\nDECLARE @ind INT=1;\n\nWHILE(@ind<1200000)\nBEGIN\n\tINSERT INTO [dbo].[Ref]\n           ([ID]\n           ,[ID2]\n           ,[Name])\n    SELECT\n           @ind\n           ,@ind\n           ,CAST(@ind AS NVARCHAR(255));\n\n\tSET @ind=@ind+1;\nEND \nGO\n<\/code><\/pre>\n
\u0410\u043d\u0430\u043b\u043e\u0433\u0438\u0447\u043d\u043e \u0437\u0430\u043f\u043e\u043b\u043d\u0438\u043c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 Customer \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0433\u043e \u0441\u043a\u0440\u0438\u043f\u0442\u0430:<\/p>\n
\u0417\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b Customer<\/b><\/p>\n
USE [TEST]\nGO\n\nDECLARE @ind INT=1;\nDECLARE @ind_ref INT=1;\n\nWHILE(@ind<=12000000)\nBEGIN\n\tIF(@ind%3=0) SET @ind_ref=1;\n\tELSE IF (@ind%5=0) SET @ind_ref=2;\n\tELSE IF (@ind%7=0) SET @ind_ref=3;\n\tELSE IF (@ind%11=0) SET @ind_ref=4;\n\tELSE IF (@ind%13=0) SET @ind_ref=5;\n\tELSE IF (@ind%17=0) SET @ind_ref=6;\n\tELSE IF (@ind%19=0) SET @ind_ref=7;\n\tELSE IF (@ind%23=0) SET @ind_ref=8;\n\tELSE IF (@ind%29=0) SET @ind_ref=9;\n\tELSE IF (@ind%31=0) SET @ind_ref=10;\n\tELSE IF (@ind%37=0) SET @ind_ref=11;\n\tELSE SET @ind_ref=@ind%1190000;\n\t\n\tINSERT INTO [dbo].[Customer]\n\t           ([ID]\n\t           ,[Name]\n\t           ,[Ref_ID]\n\t           ,[Ref_ID2])\n\t     SELECT\n\t           @ind,\n\t           CAST(@ind AS NVARCHAR(255)),\n\t           @ind_ref,\n\t           @ind_ref;\n\n\n\tSET @ind=@ind+1;\nEND\nGO\n<\/code><\/pre>\n
\u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043c\u044b \u043f\u043e\u043b\u0443\u0447\u0438\u043b\u0438 \u0434\u0432\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u0432 \u043e\u0434\u043d\u043e\u0439 \u0438\u0437 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u0431\u043e\u043b\u0435\u0435 1 \u043c\u043b\u043d \u0441\u0442\u0440\u043e\u043a \u0434\u0430\u043d\u043d\u044b\u0445, \u0430 \u0432 \u0434\u0440\u0443\u0433\u043e\u0439-\u0431\u043e\u043b\u0435\u0435 10 \u043c\u043b\u043d \u0441\u0442\u0440\u043e\u043a \u0434\u0430\u043d\u043d\u044b\u0445.<\/p>\n
\u0422\u0435\u043f\u0435\u0440\u044c \u0432 Visual Studio \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0441\u043e\u0437\u0434\u0430\u0442\u044c \u0442\u0435\u0441\u0442\u043e\u0432\u044b\u0439 \u043f\u0440\u043e\u0435\u043a\u0442 Visual C# Console App (.NET Framework):<\/p>\n
\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
\n
\n\u0414\u0430\u043b\u0435\u0435, \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0434\u043b\u044f \u0432\u0437\u0430\u0438\u043c\u043e\u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0443 \u0434\u043b\u044f Entity Framework. 
\n\u0427\u0442\u043e\u0431\u044b \u0435\u0435 \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c, \u043d\u0430\u0436\u043c\u0435\u043c \u043d\u0430 \u043f\u0440\u043e\u0435\u043a\u0442 \u043f\u0440\u0430\u0432\u043e\u0439 \u043a\u043d\u043e\u043f\u043a\u043e\u0439 \u043c\u044b\u0448\u0438 \u0438 \u0432\u044b\u0431\u0435\u0440\u0435\u043c \u0432 \u043a\u043e\u043d\u0442\u0435\u043a\u0441\u0442\u043d\u043e\u043c \u043c\u0435\u043d\u044e Manage NuGet Packages:<\/p>\n
\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
\n
\n\u0417\u0430\u0442\u0435\u043c \u0432 \u043f\u043e\u044f\u0432\u0438\u0432\u0448\u0435\u043c\u0441\u044f \u043e\u043a\u043d\u0435 \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f NuGet-\u043f\u0430\u043a\u0435\u0442\u0430\u043c\u0438 \u0432 \u043e\u043a\u043d\u0435 \u043f\u043e\u0438\u0441\u043a\u0430 \u0432\u0432\u0435\u0434\u0435\u043c \u0441\u043b\u043e\u0432\u043e \u00abEntity Framework\u00bb \u0438 \u0432\u044b\u0431\u0435\u0440\u0435\u043c \u043f\u0430\u043a\u0435\u0442 Entity Framework \u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c \u0435\u0433\u043e:<\/p>\n
\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
\n
\n\u0414\u0430\u043b\u0435\u0435 \u0432 \u0444\u0430\u0439\u043b\u0435 App.config \u043f\u043e\u0441\u043b\u0435 \u0437\u0430\u043a\u0440\u044b\u0442\u0438\u044f \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430 configSections \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0434\u043e\u0431\u0430\u0432\u0438\u0442\u044c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0431\u043b\u043e\u043a:<\/p>\n
<connectionStrings>\n    <add name=\"DBConnection\" connectionString=\"data source=\u0418\u041c\u042f_\u042d\u041a\u0417\u0415\u041c\u041f\u041b\u042f\u0420\u0410_MSSQL;Initial Catalog=TEST;Integrated Security=True;\" providerName=\"System.Data.SqlClient\" \/>\n<\/connectionStrings>\n<\/code><\/pre>\n
\n\u0412 connectionString \u043d\u0443\u0436\u043d\u043e \u0432\u043f\u0438\u0441\u0430\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0443 \u043f\u043e\u0434\u043a\u043b\u044e\u0447\u0435\u043d\u0438\u044f.<\/p>\n
\u0422\u0435\u043f\u0435\u0440\u044c \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u0444\u0430\u0439\u043b\u0430\u0445 3 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430:<\/p>\n
    \n
  1. \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430 IBaseEntityID<\/b>\n
    namespace TestLINQ\n{\n    public interface IBaseEntityID\n    {\n        int ID { get; set; }\n    }\n}\n<\/code><\/pre>\n
    \n<\/li>\n
  2. \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430 IBaseEntityName<\/b>\n
    namespace TestLINQ\n{\n    public interface IBaseEntityName\n    {\n        string Name { get; set; }\n    }\n}\n<\/code><\/pre>\n
    \n<\/li>\n
  3. \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u0430 IBaseNameInsertUTCDate<\/b>\n
    namespace TestLINQ\n{\n    public interface IBaseNameInsertUTCDate\n    {\n        DateTime InsertUTCDate { get; set; }\n    }\n}\n<\/code><\/pre>\n
    \n<\/li>\n<\/ol>\n
    \n\u0418 \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u043c \u0444\u0430\u0439\u043b\u0435 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0431\u0430\u0437\u043e\u0432\u044b\u0439 \u043a\u043b\u0430\u0441\u0441 BaseEntity \u0434\u043b\u044f \u043d\u0430\u0448\u0438\u0445 \u0434\u0432\u0443\u0445 \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0435\u0439, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0432\u043e\u0439\u0434\u0443\u0442 \u043e\u0431\u0449\u0438\u0435 \u043f\u043e\u043b\u044f:<\/p>\n
    \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u0431\u0430\u0437\u043e\u0432\u043e\u0433\u043e \u043a\u043b\u0430\u0441\u0441\u0430 BaseEntity<\/b><\/p>\n
    namespace TestLINQ\n{\n    public class BaseEntity : IBaseEntityID, IBaseEntityName, IBaseNameInsertUTCDate\n    {\n        public int ID { get; set; }\n        public string Name { get; set; }\n        public DateTime InsertUTCDate { get; set; }\n    }\n}\n<\/code><\/pre>\n
    \u0414\u0430\u043b\u0435\u0435 \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0445 \u0444\u0430\u0439\u043b\u0430\u0445 \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u043d\u0430\u0448\u0438 \u0434\u0432\u0435 \u0441\u0443\u0449\u043d\u043e\u0441\u0442\u0438:<\/p>\n
      \n
    1. \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 Ref<\/b>\n
      using System.ComponentModel.DataAnnotations.Schema;\n\nnamespace TestLINQ\n{\n    [Table(\"Ref\")]\n    public class Ref : BaseEntity\n    {\n        public int ID2 { get; set; }\n    }\n}\n<\/code><\/pre>\n
      \n<\/li>\n
    2. \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 Customer<\/b>\n
      using System.ComponentModel.DataAnnotations.Schema;\n\nnamespace TestLINQ\n{\n    [Table(\"Customer\")]\n    public class Customer: BaseEntity\n    {\n        public int Ref_ID { get; set; }\n        public int Ref_ID2 { get; set; }\n    }\n}\n<\/code><\/pre>\n
      \n<\/li>\n<\/ol>\n
      \n\u0422\u0435\u043f\u0435\u0440\u044c \u0441\u043e\u0437\u0434\u0430\u0434\u0438\u043c \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u043c \u0444\u0430\u0439\u043b\u0435 \u043a\u043e\u043d\u0442\u0435\u043a\u0441\u0442 UserContext:<\/p>\n
      \u0420\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u044f \u043a\u043b\u0430\u0441\u0441\u0430 UserContex<\/b><\/p>\n
      using System.Data.Entity;\n\nnamespace TestLINQ\n{\n    public class UserContext : DbContext\n    {\n        public UserContext()\n            : base(\"DbConnection\")\n        {\n            Database.SetInitializer<UserContext>(null);\n        }\n\n        public DbSet<Customer> Customer { get; set; }\n        public DbSet<Ref> Ref { get; set; }\n    }\n}\n<\/code><\/pre>\n
      \u041f\u043e\u043b\u0443\u0447\u0438\u043b\u0438 \u0433\u043e\u0442\u043e\u0432\u043e\u0435 \u0440\u0435\u0448\u0435\u043d\u0438\u0435 \u0434\u043b\u044f \u043f\u0440\u043e\u0432\u0435\u0434\u0435\u043d\u0438\u044f \u0442\u0435\u0441\u0442\u043e\u0432 \u043f\u043e \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0441 LINQ to SQL \u0447\u0435\u0440\u0435\u0437 EF \u0434\u043b\u044f MS SQL Server:<\/p>\n
      \"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
      \n
      \n\u0422\u0435\u043f\u0435\u0440\u044c \u0432 \u0444\u0430\u0439\u043b Program.cs \u0432\u0432\u0435\u0434\u0435\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434:<\/p>\n
      \u0424\u0430\u0439\u043b Program.cs<\/b><\/p>\n
      using System;\nusing System.Collections.Generic;\nusing System.Linq;\n\nnamespace TestLINQ\n{\n    class Program\n    {\n        static void Main(string[] args)\n        {\n            using (UserContext db = new UserContext())\n            {\n                var dblog = new List<string>();\n                db.Database.Log = dblog.Add;\n\n                var query = from e1 in db.Customer\n                            from e2 in db.Ref\n                            where (e1.Ref_ID == e2.ID)\n                                 && (e1.Ref_ID2 == e2.ID2)\n                            select new { Data1 = e1.Name, Data2 = e2.Name };\n\n                var result = query.Take(1000).ToList();\n\n                Console.WriteLine(dblog[1]);\n\n                Console.ReadKey();\n            }\n        }\n    }\n}\n<\/code><\/pre>\n
      \u0414\u0430\u043b\u0435\u0435 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u043c \u043d\u0430\u0448 \u043f\u0440\u043e\u0435\u043a\u0442.<\/p>\n
      \u0412 \u043a\u043e\u043d\u0446\u0435 \u0440\u0430\u0431\u043e\u0442\u044b \u043d\u0430 \u043a\u043e\u043d\u0441\u043e\u043b\u044c \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u0432\u0435\u0434\u0435\u043d\u043e:<\/p>\n
      \u0421\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 SQL-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
      SELECT TOP (1000) \n    [Extent1].[Ref_ID] AS [Ref_ID], \n    [Extent1].[Name] AS [Name], \n    [Extent2].[Name] AS [Name1]\n    FROM  [dbo].[Customer] AS [Extent1]\n    INNER JOIN [dbo].[Ref] AS [Extent2] ON ([Extent1].[Ref_ID] = [Extent2].[ID]) AND ([Extent1].[Ref_ID2] = [Extent2].[ID2])\n<\/code><\/pre>\n
      \u0422. \u0435. \u0432 \u0446\u0435\u043b\u043e\u043c \u0432\u0435\u0441\u044c\u043c\u0430 \u043d\u0435\u043f\u043b\u043e\u0445\u043e LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043b SQL-\u0437\u0430\u043f\u0440\u043e\u0441 \u043a \u0421\u0423\u0411\u0414 MS SQL Server.<\/p>\n
      \u0422\u0435\u043f\u0435\u0440\u044c \u0438\u0437\u043c\u0435\u043d\u0438\u043c \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0418 \u043d\u0430 \u0418\u041b\u0418 \u0432 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441\u0435:<\/p>\n
      LINQ-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
      var query = from e1 in db.Customer\n                            from e2 in db.Ref\n                            where (e1.Ref_ID == e2.ID)\n                                || (e1.Ref_ID2 == e2.ID2)\n                            select new { Data1 = e1.Name, Data2 = e2.Name };\n<\/code><\/pre>\n
      \u0418 \u0432\u043d\u043e\u0432\u044c \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u043c \u043d\u0430\u0448\u0435 \u043f\u0440\u0438\u043b\u043e\u0436\u0435\u043d\u0438\u0435.<\/p>\n
      \u0412\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0432\u044b\u043b\u0435\u0442\u0438\u0442 \u0441 \u043e\u0448\u0438\u0431\u043a\u043e\u0439, \u0441\u0432\u044f\u0437\u0430\u043d\u043d\u043e\u0439 \u0441 \u043f\u0440\u0435\u0432\u044b\u0448\u0435\u043d\u0438\u0435\u043c \u0432\u0440\u0435\u043c\u0435\u043d\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043a\u043e\u043c\u0430\u043d\u0434\u044b \u0432 30 \u0441\u0435\u043a:<\/p>\n
      \"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
      \n
      \n\u0415\u0441\u043b\u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043a\u0430\u043a\u043e\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u043f\u0440\u0438 \u044d\u0442\u043e\u043c \u0431\u044b\u043b \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d LINQ:<\/p>\n
      \"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
      \n, \u0442\u043e \u043c\u043e\u0436\u043d\u043e \u0443\u0431\u0435\u0434\u0438\u0442\u044c\u0441\u044f \u0432 \u0442\u043e\u043c, \u0447\u0442\u043e \u0432\u044b\u0431\u043e\u0440\u043a\u0430 \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u0447\u0435\u0440\u0435\u0437 \u0434\u0435\u043a\u0430\u0440\u0442\u043e\u0432\u043e \u043f\u0440\u043e\u0438\u0437\u0432\u0435\u0434\u0435\u043d\u0438\u0435 \u0434\u0432\u0443\u0445 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432 (\u0442\u0430\u0431\u043b\u0438\u0446):<\/p>\n
      \u0421\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 SQL-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
      SELECT TOP (1000) \n    [Extent1].[Ref_ID] AS [Ref_ID], \n    [Extent1].[Name] AS [Name], \n    [Extent2].[Name] AS [Name1]\n    FROM  [dbo].[Customer] AS [Extent1]\n    CROSS JOIN [dbo].[Ref] AS [Extent2]\n    WHERE [Extent1].[Ref_ID] = [Extent2].[ID] OR [Extent1].[Ref_ID2] = [Extent2].[ID2]\n<\/code><\/pre>\n
      \u0414\u0430\u0432\u0430\u0439\u0442\u0435 \u043f\u0435\u0440\u0435\u043f\u0438\u0448\u0435\u043c LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n
      \u041e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
      var query = (from e1 in db.Customer\n                   join e2 in db.Ref\n                   on e1.Ref_ID equals e2.ID\n                   select new { Data1 = e1.Name, Data2 = e2.Name }).Union(\n                        from e1 in db.Customer\n                        join e2 in db.Ref\n                        on e1.Ref_ID2 equals e2.ID2\n                        select new { Data1 = e1.Name, Data2 = e2.Name });\n<\/code><\/pre>\n
      \u0422\u043e\u0433\u0434\u0430 \u043f\u043e\u043b\u0443\u0447\u0438\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 SQL-\u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n
      SQL-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
      SELECT \n    [Limit1].[C1] AS [C1], \n    [Limit1].[C2] AS [C2], \n    [Limit1].[C3] AS [C3]\n    FROM ( SELECT DISTINCT TOP (1000) \n        [UnionAll1].[C1] AS [C1], \n        [UnionAll1].[Name] AS [C2], \n        [UnionAll1].[Name1] AS [C3]\n        FROM  (SELECT \n            1 AS [C1], \n            [Extent1].[Name] AS [Name], \n            [Extent2].[Name] AS [Name1]\n            FROM  [dbo].[Customer] AS [Extent1]\n            INNER JOIN [dbo].[Ref] AS [Extent2] ON [Extent1].[Ref_ID] = [Extent2].[ID]\n        UNION ALL\n            SELECT \n            1 AS [C1], \n            [Extent3].[Name] AS [Name], \n            [Extent4].[Name] AS [Name1]\n            FROM  [dbo].[Customer] AS [Extent3]\n            INNER JOIN [dbo].[Ref] AS [Extent4] ON [Extent3].[Ref_ID2] = [Extent4].[ID2]) AS [UnionAll1]\n    )  AS [Limit1]\n<\/code><\/pre>\n
      \u0423\u0432\u044b, \u043d\u043e \u0432 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441\u0430\u0445 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e, \u043f\u043e\u0442\u043e\u043c\u0443 \u0437\u0434\u0435\u0441\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e \u0441\u0434\u0435\u043b\u0430\u0442\u044c \u044d\u043a\u0432\u0438\u0432\u0430\u043b\u0435\u043d\u0442\u043d\u044b\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u0447\u0435\u0440\u0435\u0437 \u0434\u0432\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u043e \u043a\u0430\u0436\u0434\u043e\u043c\u0443 \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0441 \u043f\u043e\u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u044a\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435\u043c \u0438\u0445 \u0447\u0435\u0440\u0435\u0437 Union \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0441\u0440\u0435\u0434\u0438 \u0441\u0442\u0440\u043e\u043a.
      \n\u0414\u0430, \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432 \u043e\u0431\u0449\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u043f\u043e\u043b\u0443\u0447\u0430\u0442\u0441\u044f \u043d\u0435\u044d\u043a\u0432\u0438\u0432\u0430\u043b\u0435\u043d\u0442\u043d\u044b\u043c\u0438 \u0441 \u0442\u0435\u043c \u0443\u0447\u0435\u0442\u043e\u043c, \u0447\u0442\u043e \u043c\u043e\u0433\u0443\u0442 \u0431\u044b\u0442\u044c \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0435\u043d\u044b \u043f\u043e\u043b\u043d\u044b\u0435 \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u044b \u0441\u0442\u0440\u043e\u043a. \u041e\u0434\u043d\u0430\u043a\u043e, \u0432 \u0440\u0435\u0430\u043b\u044c\u043d\u043e\u0439 \u0436\u0438\u0437\u043d\u0438 \u043f\u043e\u043b\u043d\u044b\u0435 \u0434\u0443\u0431\u043b\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u0441\u0442\u0440\u043e\u043a\u0438 \u043d\u0435 \u043d\u0443\u0436\u043d\u044b \u0438 \u043e\u0442 \u043d\u0438\u0445 \u0441\u0442\u0430\u0440\u0430\u044e\u0442\u0441\u044f \u0438\u0437\u0431\u0430\u0432\u043b\u044f\u0442\u044c\u0441\u044f.<\/p>\n
      \u0422\u0435\u043f\u0435\u0440\u044c \u0441\u0440\u0430\u0432\u043d\u0438\u043c \u043f\u043b\u0430\u043d\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0434\u0432\u0443\u0445 \u044d\u0442\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432:<\/p>\n
        \n
      1. \u0434\u043b\u044f CROSS JOIN \u0432 \u0441\u0440\u0435\u0434\u043d\u0435\u043c \u0432\u0440\u0435\u043c\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f 195 \u0441\u0435\u043a:
        \n\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435<\/li>\n
      2. \u0434\u043b\u044f INNER JOIN-UNION \u0432 \u0441\u0440\u0435\u0434\u043d\u0435\u043c \u0432\u0440\u0435\u043c\u044f \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043c\u0435\u043d\u0435\u0435 24 \u0441\u0435\u043a:
        \n\"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435<\/li>\n<\/ol>\n
        \n\u041a\u0430\u043a \u0432\u0438\u0434\u043d\u043e \u0438\u0437 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432, \u0434\u043b\u044f \u0434\u0432\u0443\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u0441 \u043c\u0438\u043b\u043b\u0438\u043e\u043d\u0430\u043c\u0438 \u0437\u0430\u043f\u0438\u0441\u0435\u0439 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0432 \u0440\u0430\u0437\u044b \u0431\u044b\u0441\u0442\u0440\u0435\u0435, \u0447\u0435\u043c \u043d\u0435\u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439.<\/p>\n
        \u0414\u043b\u044f \u0432\u0430\u0440\u0438\u0430\u043d\u0442\u0430 \u0441 \u0418 \u0432 \u0443\u0441\u043b\u043e\u0432\u0438\u044f\u0445 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u0438\u0434\u0430:<\/p>\n
        LINQ-\u0437\u0430\u043f\u0440\u043e\u0441<\/b><\/p>\n
        var query = from e1 in db.Customer\n                            from e2 in db.Ref\n                            where (e1.Ref_ID == e2.ID)\n                                 && (e1.Ref_ID2 == e2.ID2)\n                            select new { Data1 = e1.Name, Data2 = e2.Name };\n<\/code><\/pre>\n
        \u043f\u043e\u0447\u0442\u0438 \u0432\u0441\u0435\u0433\u0434\u0430 \u0431\u0443\u0434\u0435\u0442 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d \u043f\u0440\u0430\u0432\u0438\u043b\u044c\u043d\u044b\u0439 SQL-\u0437\u0430\u043f\u0440\u043e\u0441, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u0431\u0443\u0434\u0435\u0442 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u0432 \u0441\u0440\u0435\u0434\u043d\u0435\u043c \u043f\u0440\u0438\u043c\u0435\u0440\u043d\u043e 1 \u0441\u0435\u043a:<\/p>\n
        \"\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435
        \n\u0422\u0430\u043a\u0436\u0435 \u0434\u043b\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0439 LINQ to Objects \u0432\u043c\u0435\u0441\u0442\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0432\u0438\u0434\u0430:<\/p>\n
        LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 (1-\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442)<\/b><\/p>\n
        var query = from e1 in seq1\n                            from e2 in seq2\n                            where (e1.Key1==e2.Key1)\n                               && (e1.Key2==e2.Key2)\n                            select new { Data1 = e1.Data, Data2 = e2.Data };\n<\/code><\/pre>\n
        \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u0438\u0434\u0430:<\/p>\n
        LINQ-\u0437\u0430\u043f\u0440\u043e\u0441 (2-\u0439 \u0432\u0430\u0440\u0438\u0430\u043d\u0442)<\/b><\/p>\n
        var query = from e1 in seq1\n                            join e2 in seq2\n                            on new { e1.Key1, e1.Key2 } equals new { e2.Key1, e2.Key2 }\n                            select new { Data1 = e1.Data, Data2 = e2.Data };\n<\/code><\/pre>\n
        \u0433\u0434\u0435:<\/p>\n
        \u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0434\u0432\u0443\u0445 \u043c\u0430\u0441\u0441\u0438\u0432\u043e\u0432<\/b><\/p>\n
        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\" } };\nPara[] 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\" } };\n<\/code><\/pre>\n
        , \u0430 \u0442\u0438\u043f Para \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n
        \u041e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u0435 \u0442\u0438\u043f\u0430 Para<\/b><\/p>\n
        class Para\n{\n        public int Key1, Key2;\n        public string Data;\n}\n<\/code><\/pre>\n
        \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u043c\u044b \u0440\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0435\u043b\u0438 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0430\u0441\u043f\u0435\u043a\u0442\u044b \u0432 \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u043a MS SQL Server.<\/p>\n
        \u041a \u0441\u043e\u0436\u0430\u043b\u0435\u043d\u0438\u044e \u0434\u0430\u0436\u0435 \u043e\u043f\u044b\u0442\u043d\u044b\u0435 \u0438 \u0432\u0435\u0434\u0443\u0449\u0438\u0435 .NET-\u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u0437\u0430\u0431\u044b\u0432\u0430\u044e\u0442 \u043e \u0442\u043e\u043c, \u0447\u0442\u043e \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u043f\u043e\u043d\u0438\u043c\u0430\u0442\u044c \u0447\u0442\u043e \u0434\u0435\u043b\u0430\u044e\u0442 \u0437\u0430 \u043a\u0430\u0434\u0440\u043e\u043c \u0442\u0435 \u0438\u043d\u0441\u0442\u0440\u0443\u043a\u0446\u0438\u0438, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u043e\u043d\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442. \u0418\u043d\u0430\u0447\u0435 \u043e\u043d\u0438 \u0441\u0442\u0430\u043d\u043e\u0432\u044f\u0442\u0441\u044f \u043a\u043e\u043d\u0444\u0438\u0433\u0443\u0440\u0430\u0442\u043e\u0440\u0430\u043c\u0438 \u0438 \u043c\u043e\u0433\u0443\u0442 \u0437\u0430\u043b\u043e\u0436\u0438\u0442\u044c \u0431\u043e\u043c\u0431\u0443 \u0437\u0430\u043c\u0435\u0434\u043b\u0435\u043d\u043d\u043e\u0433\u043e \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f \u0432 \u0431\u0443\u0434\u0443\u0449\u0435\u043c \u043a\u0430\u043a \u043f\u0440\u0438 \u043c\u0430\u0441\u0448\u0442\u0430\u0431\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u043d\u043e\u0433\u043e \u0440\u0435\u0448\u0435\u043d\u0438\u044f, \u0442\u0430\u043a \u0438 \u043f\u0440\u0438 \u043d\u0435\u0437\u043d\u0430\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u044b\u0445 \u0438\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u044f\u0445 \u0432\u043d\u0435\u0448\u043d\u0438\u0445 \u0443\u0441\u043b\u043e\u0432\u0438\u0439 \u0441\u0440\u0435\u0434\u044b.<\/p>\n
        \u0422\u0430\u043a\u0436\u0435 \u043d\u0435\u0431\u043e\u043b\u044c\u0448\u043e\u0439 \u043e\u0431\u0437\u043e\u0440 \u043f\u0440\u043e\u0432\u043e\u0434\u0438\u043b\u0441\u044f \u0438 \u0437\u0434\u0435\u0441\u044c<\/a><\/noindex>.<\/p>\n
        \u0418\u0441\u0445\u043e\u0434\u043d\u0438\u043a\u0438 \u0434\u043b\u044f \u0442\u0435\u0441\u0442\u0430-\u0441\u0430\u043c \u043f\u0440\u043e\u0435\u043a\u0442, \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446 \u0432 \u0431\u0430\u0437\u0435 \u0434\u0430\u043d\u043d\u044b\u0445 TEST, \u0430 \u0442\u0430\u043a\u0436\u0435 \u043d\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u044d\u0442\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446 \u043d\u0430\u0445\u043e\u0434\u0438\u0442\u0441\u044f \u0437\u0434\u0435\u0441\u044c<\/a><\/noindex>.
        \n\u0422\u0430\u043a\u0436\u0435 \u0432 \u044d\u0442\u043e\u043c \u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438 \u0432 \u043f\u0430\u043f\u043a\u0435 Plans \u043d\u0430\u0445\u043e\u0434\u044f\u0442\u0441\u044f \u043f\u043b\u0430\u043d\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0441 \u0443\u0441\u043b\u043e\u0432\u0438\u044f\u043c\u0438 \u0418\u041b\u0418.
        \n
        \u0418\u0441\u0442\u043e\u0447\u043d\u0438\u043a:         habr.com<\/a><\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"
        LINQ \u0432\u043e\u0448\u0435\u043b \u0432 .NET \u043a\u0430\u043a \u043d\u043e\u0432\u044b\u0439 \u043c\u043e\u0449\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0438 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. LINQ to SQL \u043a\u0430\u043a \u0447\u0430\u0441\u0442\u044c \u0435\u0433\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0443\u0434\u043e\u0431\u043d\u043e \u043e\u0431\u0449\u0430\u0442\u044c\u0441\u044f \u0441 \u0421\u0423\u0411\u0414 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 Entity Framework. \u041e\u0434\u043d\u0430\u043a\u043e, \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044f \u0435\u0433\u043e, \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u0437\u0430\u0431\u044b\u0432\u0430\u044e\u0442 \u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0430 \u0442\u043e, \u043a\u0430\u043a\u043e\u0439 \u0438\u043c\u0435\u043d\u043d\u043e SQL-\u0437\u0430\u043f\u0440\u043e\u0441 \u0431\u0443\u0434\u0435\u0442 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c queryable provider, \u0432 \u0432\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u2014 Entity Framework. \u0420\u0430\u0437\u0431\u0435\u0440\u0435\u043c \u0434\u0432\u0430 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u043c\u043e\u043c\u0435\u043d\u0442\u0430 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":27043,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-36156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Einige Aspekte der Optimierung von LINQ-Abfragen in C#.NET f\u00fcr MS SQL Server | ProHoster","description":"LINQ wurde als neue leistungsstarke Sprache zur Manipulation von Daten in .NET integriert. LINQ to SQL erm\u00f6glicht es, bequem mit Datenbankmanagementsystemen (DBMS) \u00fcber beispielsweise das Entity Framework zu kommunizieren. H\u00e4ufig vergessen Entwickler jedoch, darauf zu achten, welcher SQL-Befehl vom queryable Provider, in diesem Fall dem Entity Framework, generiert wird. Lassen Sie uns zwei grundlegende Punkte n\u00e4her betrachten.","canonical_url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/nekotorye-aspekty-optimizatsii-linq-zaprosov-v-c-net-dlya-ms-sql-server","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"de_DE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0430\u0441\u043f\u0435\u043a\u0442\u044b \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 LINQ-\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0432 C#.NET \u0434\u043b\u044f MS SQL Server | ProHoster","og:description":"LINQ \u0432\u043e\u0448\u0435\u043b \u0432 .NET \u043a\u0430\u043a \u043d\u043e\u0432\u044b\u0439 \u043c\u043e\u0449\u043d\u044b\u0439 \u044f\u0437\u044b\u043a \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u044f\u0446\u0438\u0438 \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. LINQ to SQL \u043a\u0430\u043a \u0447\u0430\u0441\u0442\u044c \u0435\u0433\u043e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0443\u0434\u043e\u0431\u043d\u043e \u043e\u0431\u0449\u0430\u0442\u044c\u0441\u044f \u0441 \u0421\u0423\u0411\u0414 \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043d\u0430\u043f\u0440\u0438\u043c\u0435\u0440 Entity Framework. \u041e\u0434\u043d\u0430\u043a\u043e, \u0434\u043e\u0441\u0442\u0430\u0442\u043e\u0447\u043d\u043e \u0447\u0430\u0441\u0442\u043e \u043f\u0440\u0438\u043c\u0435\u043d\u044f\u044f \u0435\u0433\u043e, \u0440\u0430\u0437\u0440\u0430\u0431\u043e\u0442\u0447\u0438\u043a\u0438 \u0437\u0430\u0431\u044b\u0432\u0430\u044e\u0442 \u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u043d\u0430 \u0442\u043e, \u043a\u0430\u043a\u043e\u0439 \u0438\u043c\u0435\u043d\u043d\u043e SQL-\u0437\u0430\u043f\u0440\u043e\u0441 \u0431\u0443\u0434\u0435\u0442 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c queryable provider, \u0432 \u0432\u0430\u0448\u0435\u043c \u0441\u043b\u0443\u0447\u0430\u0435 \u2014 Entity Framework. \u0420\u0430\u0437\u0431\u0435\u0440\u0435\u043c \u0434\u0432\u0430 \u043e\u0441\u043d\u043e\u0432\u043d\u044b\u0445 \u043c\u043e\u043c\u0435\u043d\u0442\u0430","og:url":"https:\/\/prohoster.info\/de\/blog\/administrirovanie\/nekotorye-aspekty-optimizatsii-linq-zaprosov-v-c-net-dlya-ms-sql-server","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:09:53+00:00","article:modified_time":"2019-10-31T19:09:53+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"36156","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-22 02:15:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 01:49:44","updated":"2026-01-22 02:15:19"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/36156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/comments?post=36156"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/posts\/36156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media\/27043"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/media?parent=36156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/categories?post=36156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/de\/wp-json\/wp\/v2\/tags?post=36156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}