Odesk Top 25 developer (Galgodage L June 2009)

Use buckets for search multiple condition

public EntityCollection GetPagesForNavByAppId(int AppId)
{
IRelationPredicateBucket bucket = new RelationPredicateBucket(PageFields.AppId == AppId & PageFields.IsActive == true);
ISortExpression sort = new SortExpression(PageFields.NavOrder | SortOperator.Descending);
EntityCollection pages = new EntityCollection();

using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(pages, bucket, 0, sort, null);
return pages;
}
}

Add new record using entity class

AppBreeder.EntityClasses.AppEntity app = new AppBreeder.EntityClasses.AppEntity();

app.UserId = 19;
app.Title = txtTitle.Text;
app.MainPageImg = txtMainPageImg.Text;
app.SplashScreenImg = txtSplashScreenImg.Text;
app.AppStoreIconImg = txtAppStoreIconImg.Text;
app.AppStoreName = txtAppStoreName.Text;
app.PrefCssSheet = txtPrefCssSheet.Text;
app.BlackBerryPubDate = System.DateTime.Now;
app.BlackBerryPubId = txtBlackBerryPubID.Text;
app.AndroidPubDate = System.DateTime.Now;
app.AndroidPubId = txtAndroidPubID.Text;
app.WebPubDate = System.DateTime.Now;
// app.WebPubId = txtWebPubID.Text;
app.AppType = dlsAppType.SelectedValue.ToString();
// AppBreeder.EntityClasses.

DataAccessAdapter adapter = new DataAccessAdapter();
adapter.SaveEntity(app);

Edit Existing Record

AppEntity application = new AppEntity(int.Parse(Session["AppID"].ToString()));
DataAccessAdapter adapter = new DataAccessAdapter(true);
adapter.FetchEntity(application);
application.Title = txtTitle.Text;
application.AppType = dlsAppType.SelectedValue;
adapter.SaveEntity(application);

note:
Fetch object before save

Use filters to retrieve data for collection

public EntityCollection GetPagesByAppId(int AppId)
{
RelationPredicateBucket filter = new RelationPredicateBucket(PageFields.AppId == AppId);

EntityCollection pages = new EntityCollection();
using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(pages, filter);
return pages;
}

}

Retrive Collection of data from llblgen

public EntityCollection GetPages()
{
EntityCollection pages = new EntityCollection(new PageEntityFactory ());
using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(pages, null);
return pages;
}

}

Retrive one object from llblgen

public AppBreeder.EntityClasses.PageEntity GetPage(int PageId)
{

PageEntity page = new PageEntity(PageId);

using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntity(page);
return page;
}


}