Expression Tree Based Condition Builder for Entity Framework & Entity Framework Core & Dapper
- Pull Source Code & Build Project:
git clone git@github.com:qinyuanpei/DynamicSearch.git
- Add Reference To Your Project:
using DynamicSearch.Core;
using DynamicSearch.Extenstions;- Example of
Entity Framework&Entity Framework Core:
var searchParameters = new SearchParameters();
searchParameters.QueryModel = new QueryModel();
searchParameters.QueryModel.Add(new Condition() { Field = "ArtistId", Op = Operation.Equals, Value = 1 });
searchParameters.QueryModel.Add(new Condition() { Field = "AlbumId", Op = Operation.StdIn, Value = new int[] { 1, 2, 3} });
var results = context.Album.Search(searchParameters);
//等价形式
var results = context.Album.Where(x => x.ArtistId == 1 & new int[] { 1, 2, 3 }.Contains(x.AlbumId))- Example of
Dapper:
using (var connection = new SQLiteConnection("Data Source=Chinook.db"))
{
var searchParameters = new SearchParameters();
searchParameters.QueryModel.Add(new Condition() { Field = "ArtistId", Op = Operation.Equals, Value = 1 });
searchParameters.QueryModel.Add(new Condition() { Field = "AlbumId", Op = Operation.StdIn, Value = new int[] { 1, 2, 3} });
var results = connection.Search<Album>(searchParameters);
//等价形式
var results = connection.Query<Album>("SELECT * FROM Album WHERE ArtistId = @ArtistId AND AlbumId IN @AlbumId",
new { ArtistId = 1, AlbumId = new int[] { 1, 2, 3 } });
}- More Features:
Equals, NotEquals, LessThan, LessThanOrEquals, GreaterThan, GreaterThanOrEquals, StdIn, StdNotIn, Contains, NotContains, StartsWith, EndsWith, Pagination, Sort