Write contained expression in LLBL Genpro

Question

How can i write some code with LLBL GenPro like that:

var myString = "Blah,Blah,Blah,Blah";
DbContext.MyTableName.Where(a => myString.Contains(a.TableFiledName.ToString()))

It's lambda expression with entity but now i want to do the same thing in LLBL Genpro, how can i do it?

Please help thanks

Answer 1

Assuming you are referring to LLBLGen Framework (LLBLGen Designer supports generating code for multiple O/RM Framerowks), this is how it would look like using QuerySpec:

var myString = "Blah,Blah,Blah,Blah";

var qf = new QueryFactory();
var q = qf.Customer.Where(CustomerFields.Country.Contains(myString));

Or very similar, using Linq2LLBL:

var myString = "Blah,Blah,Blah,Blah";

var metaData = new LinqMetaData(adapter);
var q = from c in metaData.Customer where c.Country.Contains(myString);