Hi,
I have some problems with "Relation" issue.
Lets say that I have 2 db tables named Description , Users
Description has 4 columns named :id, userid, source_type, source_id
Users has 2 columns named : id, name
Logically Description.userid refers to Users.id but physically there is no relation within database.
What i cant do is adding a relation using RelationCollection and bind to datagrid.
My code is as follows
DescriptionsCollection dc = new DescriptionsCollection();
PredicateExpression filter = new PredicateExpression();
filter.Add(DescriptionsFields.SourceId == _id);
filter.Add(DescriptionsFields.SourceType == _type);
SortExpression sort = new SortExpression(DescriptionsFields.InsertDate | SortOperator.Descending);
//IRelationCollection relations = new RelationCollection();
//relations.Add(UsersEntity.Relations.);
dc.GetMulti(filter,0,sort);
gv.DataSource = dc;
gv.DataBind();
note: there is no relation/attribute under UsersEntity.Relations.