Hi,
I changed the view from PocoWithLinQuery to TypedDataTable
updated the code to this
var pickList = new VPicklistTypedView();
var bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(VPicklistFields.Type == type.ToString());
adapter.FetchTypedView(pickList.GetFieldsInfo(), pickList, bucket, true);
Returns this...
[code]
Query: SELECT [LIMSplusv5DB].[iProducts].[vPicklists].
, [LIMSplusv5DB].[iProducts].[vPicklists].[Type], [LIMSplusv5DB].[iProducts].[vPicklists].[Description], [LIMSplusv5DB].[iProducts].[vPicklists].[ParentCode], [LIMSplusv5DB].[iProducts].[vPicklists].[IsActive] FROM [LIMSplusv5DB].[iProducts].[vPicklists] WHERE ( [LIMSplusv5DB].[iProducts].[vPicklists].[Type] = p1)
Parameter: p1 : String. Length: 20. Precision: 0. Scale: 0. Direction: Input. Value: "City".
At first I thought it had to do with maybe the LINQ code generation being the culprit, but it's leading me to believe it might have to do with the actual project being generated.
Gonna try to create a project in a new location, with no nuget packages and see how it turns out. I had this working before, seems kinda odd that updating to a different set of dlls would mess things up.
Maybe I'm not generating proper 4.5 code from LLBLGEN software.