Dynamic linq Binary and/or operator (Nhibernate linq)

dynamic-linq nhibernate

Question

I want to create an expression that as a result is a binary and or a binary or operation. Something like 

int a = 1;
int b = 2;
int c = 3;
int d = a & b; // d = 0
int e = a & c; // e = 1

I hav not found anything in dynamic linq! But in linq this is a normal expression!

public class Customer{
    [Flags]
    public enum Status{
        None = 0,
        Blocked = 1,
        Present = 2,
        Paid = 4
    }

// Holds the numeric status from database.
    public int CustomerStatusValue{get; set;}
}



var listOfCustomers = new List<Customer>(); // Would load from db...
// This works in linq
var result = listOfCustomers.Where(c => (c.CustomerStatusValue & 3) != 0); 

// This does not work!!!
var result = listOfCustomers.AsQueryable()..Where("(CustomerStatusValue & 3) != 0");
1
1
5/10/2017 10:59:10 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Based on Frédéric's suggestion, I downloaded the System.Dynamic.Linq file and changed it for '&' and '|' operatiors:

  // +, -, &, | operators
  Expression ParseAdditive()
  {
     Expression left = ParseMultiplicative();
     while (token.id == TokenId.Plus || token.id == TokenId.Minus ||
         token.id == TokenId.Amphersand || token.id == TokenId.Bar)
     {
        Token op = token;
        NextToken();
        Expression right = ParseMultiplicative();
        switch (op.id)
        {
           case TokenId.Plus:
              if (left.Type == typeof(string) || right.Type == typeof(string))
                 goto case TokenId.Amphersand;
              CheckAndPromoteOperands(typeof(IAddSignatures), op.text, ref left, ref right, op.pos);
              left = GenerateAdd(left, right);
              break;
           case TokenId.Minus:
              CheckAndPromoteOperands(typeof(ISubtractSignatures), op.text, ref left, ref right, op.pos);
              left = GenerateSubtract(left, right);
              break;
           case TokenId.Amphersand:
              if (IsNumericType(left.Type) && IsNumericType(right.Type))
              {
                 left = GenerateBinaryAnd(left, right);
              }
              else{
                 left = GenerateStringConcat(left, right);
              }
              break;
           case TokenId.Bar:
              if (IsNumericType(left.Type) && IsNumericType(right.Type))
              {
                 left = GenerateBinaryOr(left, right);
              }
              else
              {
                 left = GenerateStringConcat(left, right);
              }
              break;
        }
     }
     return left;
  }


  Expression GenerateBinaryAnd(Expression left, Expression right)
  {
     return Expression.MakeBinary(ExpressionType.And, left, right);
  }

  Expression GenerateBinaryOr(Expression left, Expression right)
  {
     return Expression.MakeBinary(ExpressionType.Or, left, right);
  }

I replaced the ParseAdditive function and created two new funtions that make a binary operation. So things like .Where("(a & B) > 0") now wioll work!!!!

It is not a final version because there are missing error checks and the name of the function 'ParseAdditive' maybe is not the right place or name, but it works.

1
5/10/2017 10:59:24 AM

Related Questions

Using the System.Linq.Dynamic namespace, how to perform the following in Dynamic Linq

I tried this:...using System; using System.Linq; using System.Linq.Dynamic; using System.Collections.Generic; namespace ConsoleApplication1 { public class Customer { public string FirstName { get; set; } public string LastName { get; set; } public string Tags { get; set; } } class Program { sta...
dynamic-linq linq
asked by MattC

Does dynamic GroupBy in dynamic LINQ work with dynamic Where?

Found it, ...db.Table1.AsQueryable()... fixed it, so ...db.Table1.AsQueryable().Where("it.FieldA>10").GroupBy("it.FieldB", "it").Select("key") ... works without exception....The problem was that Microsoft Dynamic Linq library extends ...IQueryable<Table1>..., so it does not take effect on... ObjectQuery<Table1>... which is the type of ...db.Table1....
.net dynamic dynamic-linq linq linq-to-entities
asked by alpav

LINQ-to-SQL dynamic table name LINQ-to-SQL

Looks like ...this... is the link you need. ...Update.... Some details: you can use the SearchType method from the post to obtain a type using the table name and then use ...Dynamic LINQ... to write queries you like.
dynamic-linq linq-to-sql
asked by Devart

How can I utilize System.Linq.Dynamic for the LIKE operation?

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type....something like:...var query = db.Customers. Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA") ...Just tested it with the sample app that comes with the dynamic library and it generates the LIK...
asp.net c# dynamic-linq linq
asked by Jaime

LINQ - Using NHibernate, do partial searches on many criteria. LINQ

var properties = Reporsitory.AsQueryable().Where(x => cityList.Count(c => x.StartsWith(c)) != 0); ...Or replace StartWith to Contains...
dynamic-linq linq linq-to-nhibernate
asked by Howard

OrderBy inside a GroupBy using dynamic LINQ?

This is a good question!...I simulated your situation by creating a class called Item....public class Item { public DateTime StartTime { get; set; } public string Name { get; set; } } ...and then created a basic list of items to do the groupby....List<Item> Items = new List<Item>() { new Item() { StartTime = DateTime.Today, Name = "item...
dynamic-linq linq linq-to-objects
asked by Bengel

Linq to NHibernate and Dynamic LINQ - query caching not working

Ok, I know what is the reason....Dynamic Linq doesn't use Parameter Names in Linq Expressions. E.g. if I want to sort using lambda statemant, I write:...query.OrderBy(item => item.Name) ...Above we see an ...item... lambda parameter name....When I use Dynamic linq:...query.OrderBy("Name") ...in the result Queryable the lambda parameter in OrderBy m...
dynamic-linq linq linq-to-nhibernate nhibernate
asked by cryss

System.Linq.Dynamic.Core vs System.Linq.Dynamic

System.Linq.Dynamic.Core... is more up to date and has more functionality and does also support NET Core / NETStandard (besides net35, net40 and net45 and up)...SelectMany... is indeed supported....For more information see the ...github... page and browse the examples, unit-tests and help page....Note: I'm the maintainer from this project.
dynamic-linq
asked by Stef Heyenrath

Linq Dynamic Query Issue - Operator 'OR' incompatible with operand types 'Boolean' and 'String'

Try this-... You cannot pass string inside a linq statement... valuesList = valuesList.Where(x=>x.position == 1 || x.value.Contains(3))
c# dynamic-linq linq
asked by ISHIDA

Dynamic library (System.Linq.Dynamic) SQL LIKE Operator

Since there is no LIKE operator in Dynamic Linq library, I have created it my own version. The code is not pretty, but it does work. Hopefully someone can optimize it or suggest a better way to do this....public string ParseWildcardInParameterString(string parameter, string propertyName) { string stringWithWildcard = parameter; if (paramete...
c# dynamic-linq linq sql
asked by Kevin Man

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow