Greetings,
I've made several, several attempts at getting DbLinq to work on
various projects. This time, I'm going to take some time and actually
ask if I'm doing it right.
So... I'm trying to execute this block of code in a WCF service for an
ASP.NET website:
public void UpdateLoginDate(String username)
{
var user = (from users in GetMembershipDbProvider
().Membership
where users.UserID == this.GetUserId(username)
select users).Single();
}
Just for informational purposes only, GetMembershipDbProvider, well,
returns the database provider which I am working with (I got tired of
writing the Fully-Qualified name out). Anyway, when I run the blasted
thing I get a nice little exception *splat*:
Implement QueryMethod 'GetUserId'
[ArgumentException: S0133: Implement QueryMethod 'GetUserId']
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeCall
(MethodInfo method, IList`1 parameters, BuilderContext builderContext)
in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar
\Implementation\ExpressionDispatcher.Analyzer.cs:302
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeCall
(MethodCallExpression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:178
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:109
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, BuilderContext builderContext) in C:\Users
\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:101
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeOperator
(Expression expression, BuilderContext builderContext) in C:\Users
\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:1038
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:153
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, BuilderContext builderContext) in C:\Users
\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:101
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeLambda
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:651
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:111
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeQuote
(Expression piece, IList`1 parameters, BuilderContext builderContext)
in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar
\Implementation\ExpressionDispatcher.Analyzer.cs:1013
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:115
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, Expression parameter, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:96
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeWhere
(IList`1 parameters, BuilderContext builderContext) in C:\Users\Travis
Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:624
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeCall
(MethodInfo method, IList`1 parameters, BuilderContext builderContext)
in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar
\Implementation\ExpressionDispatcher.Analyzer.cs:204
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeCall
(MethodCallExpression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:178
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, IList`1 parameters, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:109
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(Expression expression, Expression parameter, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:96
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze
(ExpressionChain expressions, Expression parameter, BuilderContext
builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq
\Data\Linq\Sugar\Implementation\ExpressionDispatcher.Analyzer.cs:73
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery
(ExpressionChain expressions, Expression tableExpression,
BuilderContext builderContext) in C:\Users\Travis Duncan\Desktop\DbLinQ
\src\DbLinq\Data\Linq\Sugar\Implementation\QueryBuilder.cs:203
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery
(ExpressionChain expressions, BuilderContext builderContext) in C:
\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar
\Implementation\QueryBuilder.cs:182
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery
(ExpressionChain expressions, QueryContext queryContext) in C:\Users
\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\QueryBuilder.cs:76
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.GetSelectQuery
(ExpressionChain expressions, QueryContext queryContext) in C:\Users
\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data\Linq\Sugar\Implementation
\QueryBuilder.cs:393
DbLinq.Data.Linq.Implementation.QueryProvider`1.GetQuery(Expression
expression) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data
\Linq\Implementation\QueryProvider.cs:165
DbLinq.Data.Linq.Implementation.QueryProvider`1.Execute(Expression
expression) in C:\Users\Travis Duncan\Desktop\DbLinQ\src\DbLinq\Data
\Linq\Implementation\QueryProvider.cs:192
System.Linq.Queryable.Single(IQueryable`1 source) +269
Yeah, yeah, we know the drill *points to short story-long stack
trace*. So, I guess the question is, does DbLinq always become this
temperamental when it comes to using method calls in where clauses?
(I tried using just a variable, by the way, and DbLinq decided it
didn't want to substitute the variable "parameter" as its actual
value).
Thanks,
-Travis
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
