Excellent... Thanks for that.
It is connecting fine, seem to be having trouble reading back from the
database now, I have tried various ways... any ideas, it seems like it
is an Ingres thing but I dont really have any experience using Ingres
and have only been using LINQ for a few months so am still getting to
grips with it.
I'm currently receiving the error...
Ingres.Client.IngresException: Local variable/parameter ':custtag'
can only be used within a database procedure.
My code is as follows:
public CustModel GetCustomerRecord(string custTag)
{
var custRecord = (
from c in _db.GetTable<CuST>()
where c.CuSTTag == custTag
select new CustModel
{
custTag = c.CuSTTag,
custCreditRate = c.CuSTCreditRate,
custCode = c.CuSTCode,
custDiscount = c.CuSTDiscount,
custName = c.CuSTName,
segmentNo = c.SegmentNo
}).FirstOrDefault<CustModel>();
return custRecord;
}
Thanks,
Paul
--
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.
