dimanche 1 novembre 2015

how to define indexing for a sqlite table with windows azure mobile services sqlite store

I have a windows mobile services with a table containing productid and productname. I'm using azure mobile services sync service to sync data with cloud. But I couldn't find a way to define index for the table in client side.

public class Product
{
    public string id;
    [JsonProperty(PropertyName = "ProductCode")]
    public int ProductCode{ get; set; }
    [JsonProperty(PropertyName = "ProductName")]
    public string ProductName { get; set; }
}

And I define the table as

var store = new MobileServiceSQLiteStore("sqlite.db");
store.DefineTable<Product>();

Now how do I define index in the sqlite table.? I couldn't find any way in msdn or any other forum.

Aucun commentaire:

Enregistrer un commentaire