Posted
by Rafael
on Stack Overflow
See other posts from Stack Overflow
or by Rafael
Published on 2009-11-04T18:56:32Z
Indexed on
2010/04/16
22:03 UTC
Read the original article
Hit count: 258
Please somebody help doing the oldest things on SubSonic.. like CRUD.
Please tell how can i do an INNER JOIN / LEFT JOIN relationship queries.
thank you very mucg.
© Stack Overflow or respective owner
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I'm starting to develop a new asp.net application based on subsonic3 (for queries) and log4net (for logs) and would like to know how to interface subsonic3 with log4net so that log4net logs the underlying sql used by subsonic.
This is what I have so far:
public static IEnumerable<arma_ocorrencium>…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi there,
I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin
var q =
from c in categories
join p in products on c equals p.Category into ps
from p in ps.DefaultIfEmpty()
select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following subsonic entities
TInvoiceHeader
TAccountAssociation
How can I achieve the following in LINQ (subsonic)
SELECT * from TInvoiceHeader
WHERE custid IN
(SELECT custid FROM TAccountAssociation
WHERE username = 'a')
I need to bind the results to a GridView.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have the following subsonic entities
TInvoiceHeader
TAccountAssociation
How can I achieve the following in LINQ
SELECT * from TInvoiceHeader
WHERE custid IN
(SELECT custid FROM TAccountAssociation
WHERE username = 'a')
I need to bind the results to a GridView.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm getting an error while trying to load an record through the constructor.
The constructor is:
public Document(Expression<Func<Document,bool>> expression);
and i try to load a single item in like this
var x = new Document(f=>f.publicationnumber=="xxx");
publicationnumber isn't…
>>> More
