I have a table called Events and one called Staff and a linking table
called EventStaff. I create a new EventStaff object and try to assign
an existing Staff record to it. I get an exception when I hit this
code:
Edu.EventStaff newEventStaff = new Edu.EventStaff();
newEventStaff.Staff =(from Edu.Staff staffMember
in EduDContext.Staff
where staffMember.ContactID ==
(int)currentBooking.EduContactID
select staffMember).Single();
S0133: Implement QueryMethod Queryable.Cast.
Stack:
at
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeQueryableCall(MethodInfo
method, IList`1 parameters, BuilderContext builderContext) in Z:
\Development\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:line 254
at
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.AnalyzeCall(MethodCallExpression
expression, IList`1 parameters, BuilderContext builderContext) in Z:
\Development\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:line 178
at
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze(Expression
expression, IList`1 parameters, BuilderContext builderContext) in Z:
\Development\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:line 109
at
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze(Expression
expression, Expression parameter, BuilderContext builderContext) in Z:
\Development\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:line 96
at
DbLinq.Data.Linq.Sugar.Implementation.ExpressionDispatcher.Analyze(ExpressionChain
expressions, Expression parameter, BuilderContext builderContext) in Z:
\Development\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\ExpressionDispatcher.Analyzer.cs:line 73
at
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery(ExpressionChain
expressions, Expression tableExpression, BuilderContext
builderContext) in Z:\Development\DbLinq-0.19\src\DbLinq\Data\Linq
\Sugar\Implementation\QueryBuilder.cs:line 203
at
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery(ExpressionChain
expressions, BuilderContext builderContext) in Z:\Development
\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\QueryBuilder.cs:line 182
at
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildExpressionQuery(ExpressionChain
expressions, QueryContext queryContext) in Z:\Development
\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\QueryBuilder.cs:line 76
at
DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.GetSelectQuery(ExpressionChain
expressions, QueryContext queryContext) in Z:\Development
\DbLinq-0.19\src\DbLinq\Data\Linq\Sugar\Implementation
\QueryBuilder.cs:line 393
at
DbLinq.Data.Linq.Implementation.QueryProvider`1.GetQuery(Expression
expression) in Z:\Development\DbLinq-0.19\src\DbLinq\Data\Linq
\Implementation\QueryProvider.cs:line 165
at DbLinq.Data.Linq.Implementation.QueryProvider`1.Execute[TResult]
(Expression expression) in Z:\Development\DbLinq-0.19\src\DbLinq\Data
\Linq\Implementation\QueryProvider.cs:line 192
at System.Linq.Queryable.Single[TSource](IQueryable`1 source)
at Danebank.EduInterface.InsertBooking() in d:\PACBookingsWebsite
\App_Code\Danebank.Bookings.cs:line 186
at _newBooking.dsLinqBookings_Inserted(Object sender,
LinqDataSourceStatusEventArgs e) in D:\PACBookingsWebsite\book
\Booking.aspx.vb:line 109
at
System.Web.UI.WebControls.LinqDataSourceView.OnInserted(LinqDataSourceStatusEventArgs
e)
at
System.Web.UI.WebControls.LinqDataSourceView.ExecuteInsert(IDictionary
values)
at System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback)
Where am I going wrong?
--
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.
