Parameters cannot be sequences

Dec 11, 2008 at 11:34 AM
CompiledQuery_GetWidgetsByRole throws a System.NotSupportedException when Im enabling the role provider: Paramters cannot be sequences (translated)

Anyone sharing my problem? According to this forum post queries with list parameters cannot be precompiled. Isnt that the case here?

Stack trace:
[NotSupportedException: Parametrar får inte vara sekvenser.] System.Data.Linq.SqlClient.QueryConverter.CoerceToSequence(SqlNode node) +887443 System.Data.Linq.SqlClient.QueryConverter.VisitContains(Expression sequence, Expression value) +465 System.Data.Linq.SqlClient.QueryConverter.VisitSequenceOperatorCall(MethodCallExpression mc) +9129
System.Data.Linq.SqlClient.QueryConverter.VisitMethodCall(MethodCallExpression mc) +74
System.Data.Linq.SqlClient.QueryConverter.VisitInner(Expression node) +1003
System.Data.Linq.SqlClient.QueryConverter.Visit(Expression node) +18
System.Data.Linq.SqlClient.QueryConverter.VisitExpression(Expression exp) +18
System.Data.Linq.SqlClient.QueryConverter.VisitWhere(Expression sequence, LambdaExpression predicate) +125
System.Data.Linq.SqlClient.QueryConverter.VisitSequenceOperatorCall(MethodCallExpression mc) +3403
System.Data.Linq.SqlClient.QueryConverter.VisitMethodCall(MethodCallExpression mc) +74
System.Data.Linq.SqlClient.QueryConverter.VisitInner(Expression node) +1003
System.Data.Linq.SqlClient.QueryConverter.Visit(Expression node) +18
System.Data.Linq.SqlClient.QueryConverter.VisitOrderBy(Expression sequence, LambdaExpression expression, SqlOrderType orderType) +77
System.Data.Linq.SqlClient.QueryConverter.VisitSequenceOperatorCall(MethodCallExpression mc) +8217
System.Data.Linq.SqlClient.QueryConverter.VisitMethodCall(MethodCallExpression mc) +74
System.Data.Linq.SqlClient.QueryConverter.VisitInner(Expression node) +1003
System.Data.Linq.SqlClient.QueryConverter.VisitLambda(LambdaExpression lambda) +428
System.Data.Linq.SqlClient.QueryConverter.VisitInner(Expression node) +1326
System.Data.Linq.SqlClient.QueryConverter.ConvertOuter(Expression node) +79
System.Data.Linq.SqlClient.SqlProvider.BuildQuery(Expression query, SqlNodeAnnotations annotations) +114
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Compile(Expression query) +76
System.Data.Linq.CompiledQuery.ExecuteQuery(DataContext context, Object[] args) +104
System.Data.Linq.CompiledQuery.Invoke(TArg0 arg0, TArg1 arg1) +87
Dropthings.DataAccess.<>c__DisplayClass26`3.<GetQueryResult>b__25(DropthingsDataContext data) in C:\TempProjects\Dropthings\trunk\DashboardDataAccess\DatabaseHelper.cs:315
Dropthings.DataAccess.DatabaseHelper.InDataContext(SubsystemEnum subsystem, Func`2 f) in C:\TempProjects\Dropthings\trunk\DashboardDataAccess\DatabaseHelper.cs:100
Dropthings.DataAccess.DatabaseHelper.GetQueryResult(SubsystemEnum subsystem, TArg0 arg0, Func`3 func, Func`2 returnExpected) in C:\TempProjects\Dropthings\trunk\DashboardDataAccess\DatabaseHelper.cs:313
Dropthings.DataAccess.DatabaseHelper.GetList(SubsystemEnum subsystem, TArg0 arg0, Func`3 func) in C:\TempProjects\Dropthings\trunk\DashboardDataAccess\DatabaseHelper.cs:440
Dropthings.Business.DashboardFacade.GetWidgetList(String[] roles) in C:\TempProjects\Dropthings\trunk\DashboardBusiness\DashboardFacade.cs:206
WidgetListControl.get_WidgetList() in c:\TempProjects\Dropthings\trunk\Dropthings\Units\WidgetListControl.ascx.cs:36
WidgetListControl.LoadWidgetList() in c:\TempProjects\Dropthings\trunk\Dropthings\Units\WidgetListControl.ascx.cs:78
WidgetListControl.LoadWidgetList(WidgetPanelRefreshHandler widgetAddedCallback) in c:\TempProjects\Dropthings\trunk\Dropthings\Units\WidgetListControl.ascx.cs:60
_Default.LoadAddStuff() in c:\TempProjects\Dropthings\trunk\Dropthings\Default.aspx.cs:207
_Default.CreateChildControls() in c:\TempProjects\Dropthings\trunk\Dropthings\Default.aspx.cs:82
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +44
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842