Hello All,
Select Issue
var q = from planTable in cispDB.Plan
where (planTable.PlanNo == "ABC1234" ||
planTable.PlanNo == "ABC1235")
join planLaTable in cispDB.PlanLa on
planTable.PlanNo equals planLaTable.PlanNo
join localAuthTable in cispDB.LocalAUtH on
planLaTable.LaCode equals localAuthTable.LaCode
select new { planTable.PlanNo ,
planLaTable.LaCode, localAuthTable.LaName, planTable.TownCode };
Investigation showed that the eventual SQL query did not bracket the
OR at all. To get it to work temporarily I changed SqlBuilder.cs in
the BuildWhere method and added
if (!IsHavingClause(whereExpression))
{
string be = BuildExpression(whereExpression,
queryContext);
if (be.Contains("OR"))
be = "(" + be + ")";
whereClauses.Add(be);
//whereClauses.Add(BuildExpression
(whereExpression, queryContext));
}
Update Issue
I cannot get it to update a field ! Code I am using is beow, if
anybody has got an update to work with Ingres (I'm using Ingres 2.6 at
the moment) I would be most appreciated of some help.
CISpProd cispDB = new CISpProd(new IngresConnection
(connString));
Plan pl = (from c in cispDB.Plan
where c.PlanNo == "ABC1234"
select c).First<Plan>();
pl.TownCode = "Jim";
cispDB.SubmitChanges();
Hoping somebody can assist
Thanks,
Jim
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
