I changet the order
MyDataContext dc = new MyDataContext(conn);
var q = from stuff in dc.stuffs
join price in dc.prices
on stuff.sifra equals price.sifra
into stuff_price
from ac in stuff_price.DefaultIfEmpty()
where
stuff.name.ToLower().Contains(tbSearch.Text.ToLower())
||
stuff.shortname.ToLower().Contains(tbSearch.Text.ToLower())
select new
{
stuff.name
*, **ac.price*
};
and changed the type of dc.prices.price form decimal to decimal?
(nullable).
Does this mean i should do this manually every time i generate datacontext
after datamodel change?
--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/dblinq/-/ekdhMuykb6AJ.
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.
