AND you're even in Richmond too. Really, really small world. OK, I'll stop spamming the list.
On Jun 23, 11:04 pm, xanadont <[email protected]> wrote: > Whoa, I just noticed you're a fellow Hokie. Small world! > > On Jun 23, 10:59 pm, xanadont <[email protected]> wrote: > > > > > Yep, here you go: > > > at > > DbLinq.Vendor.Implementation.SqlProvider.GetLiteral(ExpressionType > > operationType, IList`1 p) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildExpression(Expression > > expression, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildExpression(Expression > > expression, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildExpression(Expression > > expression, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildWhere(IList`1 > > tables, IList`1 wheres, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.Build(SelectExpression > > selectExpression, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.SqlBuilder.BuildSelect(ExpressionQuer > > y > > expressionQuery, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.BuildSqlQuery(Expression > > Query > > expressionQuery, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Sugar.Implementation.QueryBuilder.GetSelectQuery(Expressio > > nChain > > expressions, QueryContext queryContext) > > at > > DbLinq.Data.Linq.Implementation.QueryProvider`1.GetQuery(Expression > > expression) > > at DbLinq.Data.Linq.Implementation.QueryProvider`1.Execute[TResult] > > (Expression expression) > > at System.Linq.Queryable.Single[TSource](IQueryable`1 source) > > at Tester.Program.DataAccess() in C:\...\Program.cs:line 25 > > at Tester.Program.Main(String[] args) in C:\...\Program.cs:line 15 > > at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, > > String[] args) > > at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence > > assemblySecurity, String[] args) > > at > > Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() > > at System.Threading.ThreadHelper.ThreadStart_Context(Object state) > > at System.Threading.ExecutionContext.Run(ExecutionContext > > executionContext, ContextCallback callback, Object state, Boolean > > ignoreSyncCtx) > > at System.Threading.ExecutionContext.Run(ExecutionContext > > executionContext, ContextCallback callback, Object state) > > at System.Threading.ThreadHelper.ThreadStart() > > > I'm not sure what you mean by "with the exception that you can't use > > 'new' to create new Entity instances" > > > This is sort of a mission critical component for my current project. > > And although I can move specific queries into my repository classes as > > a work-around to this issue, I'd rather just return an IQueryable from > > my repository classes instead. This is critical enough that I might > > be willing to pay for a definitive fix. Can you contact me off list? > > > Thanks. > > -Abe > > > On Jun 22, 2:25 pm, Jonathan Pryor <[email protected]> wrote: > > > > On Wed, 2010-05-19 at 20:54 -0700, xanadont wrote: > > > > Is it possible to project types generated by DbLinq to other types? > > > > For example: > > > > > var mine = from i in Context.Items > > > > select new MyItem > > > > { > > > > Id = i.ID, > > > > Value = i.Value > > > > }; > > > > > I'm getting exceptions where the Message is simply "New". Is there a > > > > work around for this? > > > > Can you provide a full stack trace? This should work, with the exception > > > that you can't use 'new' to create new Entity instances; see > > > ExpressionDispatercher.Analyzer.cs:AnalyzeSelect(): > > > > protected virtual Expression AnalyzeSelect(IList<Expression> > > > parameters, BuilderContext builderContext) > > > { > > > // just call back the underlying lambda (or quote, whatever) > > > Expression ex = Analyze(parameters[1], parameters[0], > > > builderContext); > > > > > > > //http://social.msdn.microsoft.com/Forums/en-US/linqprojectgeneral/thre... > > > if (ex.NodeType == ExpressionType.MemberInit && > > > > > > builderContext.QueryContext.DataContext.Mapping.GetMetaType(ex.Type) != > > > null) > > > throw new NotSupportedException( > > > string.Format("Explicit construction of entity type > > > '{0}' in query is not allowed.", > > > ex.Type.FullName)); > > > TableExpression tableExpression = parameters[0] as > > > TableExpression; > > > if (tableExpression != null && > > > builderContext.CurrentSelect.Tables.Count == 0) > > > RegisterTable(tableExpression, builderContext); > > > return ex; > > > } > > > > - Jon -- 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.
