1)Do you have examples of creating multiple indexes on a table similar to a relational table. I am trying to take a 5 or 6 tables in my relational schema and port it over to windows phone for an app and decided to try Sterling out.
The entities are mapped to the table and the columns to properties. Each of the entities/tables has multiples indexes to support search by different keys.
2) How can i efficiently load all the rows in the table without iterating over them one by one like below..
List<ItemGroup> itemGroups = new List<ItemGroup>();
foreach (var itemGroup in database.Query<ItemGroup, int>())
3) Some of the tables have auto gen id and entities have been generated based on that, would it be possible to get some kind of auto gen iof the ids. I am planning to roll my own auto gen id tracking right now. If there are plans to implement, please
let me know
4) Some of the queries would need 'join' to other entities to pull data for the viewmodel like shown below. Can this be done and if yes, would you be able to direct me to some samples? If I am using the wrong tool to do this kind of thing, please let me
know right now
var query = from i in store.Items
join ig in store.ItemGroups on i.ItemGroupId equals ig.ItemGroupId
join ild in store.ItemLocationDetails on i.ItemId equals ild.ItemId
join l in store.Locations on ild.LocationId equals l.LocationId
join lg in store.LocationGroups on l.LocationGroupId equals lg.LocationGroupId
where l.LocationId == locationId
select new ItemLocation()
Item = i,
ItemLocationDetail = ild,
ItemGroup = ig,
Location = l,
LocationGroup = lg