Black Art – LINQ expressions reuse

Asher Barak

Rate me:

4.94/5 (16 votes)

2 Apr 2017CDDL8 min read

61.5K

312

When developing a complex line of business system queries, reuse is often required. This article provides some guidelines and tools for LINQ expressions reuse.

LinqExpressionsReuse_v1.0.zip
- LinqExpressionProjection.Test
  - bin
    - Debug
      - Dependencies
        
        EntityFramework.dll
      - EntityFramework.dll
      - LinqExpressionProjection.dll
      - LinqExpressionProjection.pdb
      - LinqExpressionProjection.Test.dll
      - LinqExpressionProjection.Test.pdb
    - Release
  - Dependencies
    - EntityFramework.dll
  - LinqExpressionProjection.Test.csproj
  - LinqExpressionProjection.Test.csproj.vspscc
  - LinqExpressionsProjection_TestFixture.cs
  - Model
  - obj
    - Debug
      - DesignTimeResolveAssemblyReferencesInput.cache
      - LinqExpressionProjection.Test.csproj.FileListAbsolute.txt
      - LinqExpressionProjection.Test.dll
      - LinqExpressionProjection.Test.pdb
      - ResolveAssemblyReference.cache
      - TempPE
  - Properties
    - AssemblyInfo.cs
- LinqExpressionProjection
  - bin
    - Debug
      - LinqExpressionProjection.dll
      - LinqExpressionProjection.pdb
    - Release
  - ExpressionVisitor.cs
  - Extensions.cs
  - LinqExpressionProjection.csproj
  - LinqExpressionProjection.csproj.vspscc
  - obj
    - Debug
      - DesignTimeResolveAssemblyReferencesInput.cache
      - LinqExpressionProjection.csproj.FileListAbsolute.txt
      - LinqExpressionProjection.dll
      - LinqExpressionProjection.pdb
      - TempPE
  - ParameterRebinder.cs
  - ProjectionExpressionExpander.cs
  - ProjectionSupportingQuery.cs
  - Properties
    - AssemblyInfo.cs
  - ReadMe.txt
- LinqExpressionsReuse.sln
- LinqExpressionsReuse.suo
- LinqExpressionsReuse
  - bin
    - Debug
      - EF_ReuseLinq.exe
      - EF_ReuseLinq.pdb
      - EF_ReuseLinq.vshost.exe
      - EF_ReuseLinq.vshost.exe.manifest
      - EntityFramework.dll
      - LinqExpressionProjection.dll
      - LinqExpressionProjection.pdb
  - Dependencies
    - EntityFramework.dll
  - EF_ReuseLinq.csproj.user
  - LinqExpressionsReuse.csproj
  - Model
  - obj
    - x86
      - Debug
        
        DesignTimeResolveAssemblyReferencesInput.cache
        
        EF_ReuseLinq.csproj.FileListAbsolute.txt
        
        EF_ReuseLinq.exe
        
        EF_ReuseLinq.pdb
        
        LinqExpressionsReuse.csproj.FileListAbsolute.txt
        
        ResolveAssemblyReference.cache
        
        TempPE
  - packages.config
  - Program.cs
  - Properties
    - AssemblyInfo.cs
- TestResults
  - Asher_PC1600 2012-06-12 16_37_14.trx
  - Asher_PC1600 2012-06-12 16_37_14
    - Out
      - EntityFramework.dll
      - LinqExpressionProjection.dll
      - LinqExpressionProjection.pdb
      - linqexpressionprojection.test.dll
      - LinqExpressionProjection.Test.pdb
linqexpressionsreuse_v1.0.zip
- EntityFramework.dll
- EntityFramework.dll
- LinqExpressionProjection.dll
- LinqExpressionProjection.pdb
- LinqExpressionProjection.Test.dll
- LinqExpressionProjection.Test.pdb
- EntityFramework.dll
- LinqExpressionProjection.Test.csproj
- LinqExpressionProjection.Test.csproj.vspscc
- LinqExpressionsProjection_TestFixture.cs
- Project.cs
- ProjectsDbContext.cs
- Subproject.cs
- DesignTimeResolveAssemblyReferencesInput.cache
- LinqExpressionProjection.Test.csproj.FileListAbsolute.txt
- LinqExpressionProjection.Test.dll
- LinqExpressionProjection.Test.pdb
- ResolveAssemblyReference.cache
- AssemblyInfo.cs
- LinqExpressionProjection.dll
- LinqExpressionProjection.pdb
- ExpressionVisitor.cs
- Extensions.cs
- LinqExpressionProjection.csproj
- LinqExpressionProjection.csproj.vspscc
- DesignTimeResolveAssemblyReferencesInput.cache
- LinqExpressionProjection.csproj.FileListAbsolute.txt
- LinqExpressionProjection.dll
- LinqExpressionProjection.pdb
- ParameterRebinder.cs
- ProjectionExpressionExpander.cs
- ProjectionSupportingQuery.cs
- AssemblyInfo.cs
- ReadMe.txt
- LinqExpressionsReuse.sln
- LinqExpressionsReuse.suo
- EF_ReuseLinq.exe
- EF_ReuseLinq.pdb
- EF_ReuseLinq.vshost.exe
- EF_ReuseLinq.vshost.exe.manifest
- EntityFramework.dll
- LinqExpressionProjection.dll
- LinqExpressionProjection.pdb
- EntityFramework.dll
- EF_ReuseLinq.csproj.user
- LinqExpressionsReuse.csproj
- Project.cs
- ProjectsDbContext.cs
- Subproject.cs
- DesignTimeResolveAssemblyReferencesInput.cache
- EF_ReuseLinq.csproj.FileListAbsolute.txt
- EF_ReuseLinq.exe
- EF_ReuseLinq.pdb
- LinqExpressionsReuse.csproj.FileListAbsolute.txt
- ResolveAssemblyReference.cache
- packages.config
- Program.cs
- AssemblyInfo.cs
- Asher_PC1600 2012-06-12 16_37_14.trx
- EntityFramework.dll
- LinqExpressionProjection.dll
- LinqExpressionProjection.pdb
- linqexpressionprojection.test.dll
- LinqExpressionProjection.Test.pdb


Microsoft Visual Studio Solution File, Format Version 11.00
# Visual Studio 2010
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "LinqExpressionProjection", "LinqExpressionProjection\LinqExpressionProjection.csproj", "{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "LinqExpressionProjection.Test", "LinqExpressionProjection.Test\LinqExpressionProjection.Test.csproj", "{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}"
EndProject
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "LinqExpressionsReuse", "LinqExpressionsReuse\LinqExpressionsReuse.csproj", "{1E3824FB-0A63-4D4F-91FA-649CCEF63159}"
EndProject
Global
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
		Debug|Any CPU = Debug|Any CPU
		Debug|Mixed Platforms = Debug|Mixed Platforms
		Debug|x86 = Debug|x86
		Release|Any CPU = Release|Any CPU
		Release|Mixed Platforms = Release|Mixed Platforms
		Release|x86 = Release|x86
	EndGlobalSection
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Debug|x86.ActiveCfg = Debug|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Release|Any CPU.Build.0 = Release|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{DD149C86-76EE-40EF-80F0-4055EE0AD8B7}.Release|x86.ActiveCfg = Release|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Debug|Any CPU.Build.0 = Debug|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Debug|Mixed Platforms.ActiveCfg = Debug|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Debug|Mixed Platforms.Build.0 = Debug|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Debug|x86.ActiveCfg = Debug|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Release|Any CPU.ActiveCfg = Release|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Release|Any CPU.Build.0 = Release|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Release|Mixed Platforms.ActiveCfg = Release|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Release|Mixed Platforms.Build.0 = Release|Any CPU
		{C8FC2631-8BB0-4BEA-AB92-1D3A618D98B3}.Release|x86.ActiveCfg = Release|Any CPU
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Debug|Any CPU.ActiveCfg = Debug|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Debug|Mixed Platforms.ActiveCfg = Debug|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Debug|Mixed Platforms.Build.0 = Debug|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Debug|x86.ActiveCfg = Debug|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Debug|x86.Build.0 = Debug|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Release|Any CPU.ActiveCfg = Release|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Release|Mixed Platforms.ActiveCfg = Release|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Release|Mixed Platforms.Build.0 = Release|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Release|x86.ActiveCfg = Release|x86
		{1E3824FB-0A63-4D4F-91FA-649CCEF63159}.Release|x86.Build.0 = Release|x86
	EndGlobalSection
	GlobalSection(SolutionProperties) = preSolution
		HideSolutionNode = FALSE
	EndGlobalSection
EndGlobal

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Common Development and Distribution License (CDDL)

Written By

Asher Barak

Chief Technology Officer Ziv systems, Israel

Israel

Starting with Apple IIe BASICA, and working my way through Pascal, Power Builder, Visual basic (and the light office VBA) C, C++, I am now a full stack developer and development manager. Mostly with MS technologies on the server side and javascript(typescript) frameworks on the client side.

Black Art – LINQ expressions reuse

License

Comments and Discussions