Hi All,
This one has had me stumped for a while:
I have three tables in the database
1. MyTable
- MyTableId
- Name
2. MyTable_Attachment
- MyTableId
- AttachmentId
3. Attachments
- AttachmentId
- FileName
- Blob
I have two classes
MyTable
Id
. Name
...
Attachment
Id
FileName
Blob
...
I have a mapping for MyTable
mapping.HasManyToMany(x => x.Attachments)
.Table("MyTable_Attachment")
.ParentKeyColumn("MyTableId")
.ChildKeyColumn("AttachmentId")
I can get a MyTable object and loop through the Attachments, however a
blob field is undesirable as it could be large.
I cannot remove the blob field( that I need to remove) to display a
list of attachments -File Names and Id's for MyTable.
I am trying to do something like this:
SELECT a.AttachmentId, a.FileName
FROM Attachment AS a INNER JOIN MyTable_Attachment AS ma
ON a.AttachmentId = ma.AttachmentId
WHERE (ma.MyTableId =10)
Maybe it is something that I have just been trying to hard at but any
suggestion would be greatly appreciated!.
--
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en.
