Art of BI: Simple SubSonic Project Collection Retrieve
Author: Christian Screen | | July 4, 2009
Using the subsonic project ORM for .NET clearly has tons of benefits for DAL and BLL purposes.
A great way to get a list of records from the db is to use the collection object which is created for tables and view objects from the db.
Here are two examples of how to use the .Load() method and overload to get data in a collection for which you can loop through using a foreach() statement.
Using the Query Object with Collection Object
Query q = new Query(Views.Accounts);
q.WHERE("accountID", Comparison.Equals, _accountID.value.ToString());
AccountsCollection obj1 = new AccountsCollection();
obj1.Load(q.ExecuteReader());
Using only the Collection Object
AccountsCollection obj1 = new AccountsCollection().Where("accountID", Comparison.Equals, accountID.value.ToString()).Load();
Now, to loop through the Collection
Once the collection has been instantiated and the Load() method called a foreach() loop can take place to get the records.
if (obj1.Count > 0)
{
foreach (Accounts x in obj1)
{
Console.Write("My Account Name is {0}", x.AccountName);
}
}
else
Console.Write("There are no accounts in the collection");
Related Posts
Oracle BI Publisher (BIP) Tips: Functions, Calculations & More
Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.
How to Index a Fact Table – A Best Practice
At the base of any good BI project is a solid data warehouse or data mart.
Qlik vs. Tableau vs. Power BI: Which BI Tool Is Right for You?
Tableau, Power BI, and Qlik each have their benefits. What are they and how do you choose? Read this blog post for a quick analysis.