An item with the same key has already been added.
Posts
Posts: 23
Joined: 14-May-2007
Joined: 14-May-2007
Posts: 23
Joined: 14-May-2007
Joined: 14-May-2007
Posts: 23
Joined: 14-May-2007
Joined: 14-May-2007
Further to my previous post, I attempted with sample project to use Outer Joins vs Inner Join and am now getting "onClause can't be null <br >Parameter name: onClause.
Linq Query:
var testItems = from m in metaData.MasterTable
join c1 in metaData.ChildTable1 on m.Id equals c1.MasterId into c1_1
join c2 in metaData.ChildTable2 on m.Id equals c2.MasterId into c2_1
join c3 in metaData.ChildTable3 on m.Id equals c3.MasterId into c3_1
from c1_2 in c1_1.DefaultIfEmpty()
from c2_2 in c2_1.DefaultIfEmpty()
from c3_2 in c3_1.DefaultIfEmpty()
select new { m.Id, m.Field1, c1Field1 = c1_2.Field1, c2field1 = c2_2.Field1, c3field1 = c3_2.Field1 };
Stacktrace:
onClause can't be null
Parameter name: onClause
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentNullException: onClause can't be null
Parameter name: onClause
Source Error:
Line 65: public DynamicRelation(EntityType leftOperand, JoinHint joinType, EntityType rightOperand, string aliasLeftOperand, string aliasRightOperand, IPredicate onClause)
Line 66: {
Line 67: base.InitClass(joinType, aliasLeftOperand, aliasRightOperand, onClause, GeneralEntityFactory.Create(leftOperand), GeneralEntityFactory.Create(rightOperand));
Line 68: }
Line 69:
Source File: C:\Testing\VStudio2008\Projects\LLBLGenTesting\LinqTesting2\ClassLibs\DatabaseGeneric\RelationClasses\DynamicRelation.cs Line: 67
Stack Trace:
[ArgumentNullException: onClause can't be null
Parameter name: onClause]
SD.LLBLGen.Pro.ORMSupportClasses.DynamicRelationBase.InitClass(JoinHint joinType, String aliasLeftOperand, String aliasRightOperand, IPredicate onClause, Object leftOperand, Object rightOperand) +298
LinqTesting.RelationClasses.DynamicRelation..ctor(EntityType leftOperand, JoinHint joinType, EntityType rightOperand, String aliasLeftOperand, String aliasRightOperand, IPredicate onClause) in C:\Testing\VStudio2008\Projects\LLBLGenTesting\LinqTesting2\ClassLibs\DatabaseGeneric\RelationClasses\DynamicRelation.cs:67
LinqTesting.Linq.ElementCreator.CreateDynamicRelation(String leftOperandEntityName, JoinHint joinType, String rightOperandEntityName, String aliasLeftOperand, String aliasRightOperand, IPredicate onClause) in C:\Testing\VStudio2008\Projects\LLBLGenTesting\LinqTesting2\ClassLibs\DatabaseGeneric\Linq\LinqMetaData.cs:194
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.CreateDynamicRelation(Object left, Object right, JoinHint joinType, String aliasLeft, String aliasRight, IPredicate onClause) +420
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleJoinExpression(JoinExpression expressionToHandle) +1218
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.GenericExpressionHandler.HandleExpression(Expression expressionToHandle) +837
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleExpression(Expression expressionToHandle) +74
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleAndProcessJoinExpressionSide(SetExpression side, Expression sideSelector, Expression& handledSide, Expression& handledSideSelector, String& aliasSide) +22
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleJoinExpression(JoinExpression expressionToHandle) +486
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.GenericExpressionHandler.HandleExpression(Expression expressionToHandle) +837
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleExpression(Expression expressionToHandle) +74
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleAndProcessJoinExpressionSide(SetExpression side, Expression sideSelector, Expression& handledSide, Expression& handledSideSelector, String& aliasSide) +22
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleJoinExpression(JoinExpression expressionToHandle) +486
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.GenericExpressionHandler.HandleExpression(Expression expressionToHandle) +837
SD.LLBLGen.Pro.LinqSupportClasses.ExpressionHandlers.QueryExpressionBuilder.HandleExpression(Expression expressionToHandle) +74
SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.HandleExpressionTree(Expression expression) +853
SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.Execute(Expression expression) +10
SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProProviderBase.System.Linq.IQueryProvider.Execute(Expression expression) +4
SD.LLBLGen.Pro.LinqSupportClasses.LLBLGenProQuery`1.System.Collections.IEnumerable.GetEnumerator() +13
System.Web.UI.WebControls.PagedDataSource.GetEnumerator() +171
System.Web.UI.WebControls.DataGrid.CreateAutoGeneratedColumns(PagedDataSource dataSource) +254
System.Web.UI.WebControls.DataGrid.CreateColumnSet(PagedDataSource dataSource, Boolean useDataSource) +1629786
System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) +295
System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +56
System.Web.UI.WebControls.BaseDataList.DataBind() +52
_Default.Page_Load(Object sender, EventArgs e) in c:\Testing\VStudio2008\Projects\LLBLGenTesting\LinqTesting2\WebSite\Default.aspx.cs:84
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436
I'm admittedly very, very new to Linq so....I hope this isn't a goose chase 
Thanks,
Shawn
Thanks for the extra info! I think this will be enough to get things setup here 
Posts: 23
Joined: 14-May-2007
Joined: 14-May-2007
Posts: 23
Joined: 14-May-2007
Joined: 14-May-2007
Thanks for the effort! 
I could reproduce the first issue with northwind:
var q = from e in metaData.Employee
join e2 in metaData.Employee on e.EmployeeId equals e2.ReportsTo
join o in metaData.Order on e.EmployeeId equals o.EmployeeId
join et in metaData.EmployeeTerritory on e.EmployeeId equals et.EmployeeId
select new { e.LastName, e.EmployeeId, Manager = e2.LastName, o.OrderId, et.TerritoryId };
so I can add a unittest to the pack for it. I'll now see if your fix has any impact on the rest of the code.
It's caused by the fact that there are several projections (each join has a projection, which is handled but in the end not used, but that's unknown at that point) and a projection is merged into another, which has its uniquecounter set to 0 initially. In this case the ID shows up multiple times and it twice gets the value Id0.
A slightly more efficient patch:
// different field, cook up new name
string tmpNewName = string.Empty;
do
{
tmpNewName = nameToUse += _uniqueNameCounter.ToString();
_uniqueNameCounter++;
}
while(this.ElementsPerName.ContainsKey(tmpNewName));
nameToUse = tmpNewName;
I'll now look into your guid issue.
That issue is caused by the CreateOnClausePredicate routine which is a little retarded. 
Say you do this:
var q = from c in metaData.Customer
join e in metaData.Employee on c.CustomerId[0] equals e.LastName[0]
select new { c.CustomerId, e.EmployeeId, e.LastName };
You get the same error, as it doesn't anticipate that it can expect a db function call wrapped inside an llblexpression.
The 'Convert' can be stripped off in general, though not always: nullability converts can be stripped off in many cases, the converts between types can't. I'll make sure this works properly (I can repro the issue with convert as well:
var q = from e in metaData.Employee
join e2 in metaData.Employee on e.EmployeeId equals e2.ReportsTo into j1
join o in metaData.Order on e.EmployeeId equals o.EmployeeId into j2
join et in metaData.EmployeeTerritory on e.EmployeeId equals et.EmployeeId into j3
from x1 in j1.DefaultIfEmpty()
from x2 in j2.DefaultIfEmpty()
from x3 in j3.DefaultIfEmpty()
select new { e.LastName, e.EmployeeId, Manager = x1.LastName, x2.OrderId, x3.TerritoryId };