return array from db.execute or db.query

Question

i want to return an array to from winrt(c#) so i have two way either through db.execute or db.query... please suggest me what should i do for returning array:

public static string getQX(string Squery)
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                var qu = db.Query<NR_FS_FW_TASK_TYPES>(Squery);
               //return resultset in array
            }
        }

---or-----

public static string getQXn(string Squery)
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                db.Execute(Squery); 
                //return resultset in array

            }
        }

please suggest, any new idea also appreciated

Answer 1

db.Execute can not return an array, it's not meant to be used for SELECT statements.

db.Query returns a list, which can be transformed into an array (requires a using statement for System.Collections.Generic on top of your file):

public static NR_FS_FW_TASK_TYPES[] getQX(string Squery)
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                var qu = db.Query<NR_FS_FW_TASK_TYPES>(Squery);
                return qu.ToArray();
            }
        }

Answer 2

it will return generic array i just want to return normal string array, is this possible??

my class is:

 public class NR_FS_FW_TASK_TYPES
        {
            string TASK_TYPE_ID { get; set; } string NAME { get; set; }
        }

Answer 3

The following code returns the names of the selected instances as a string array (it requires a using statement for System.Linq on top of your file):

public static string[] getQX(string Squery)
{
    var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "NRFS.db3");
    using (var db = new SQLite.SQLiteConnection(dbpath))
    {
        var qu = db.Query<NR_FS_FW_TASK_TYPES>(Squery);
        return qu.Select(t => t.NAME).ToArray();
    }
}

If that's not what you want, then please explain in more detail how you want the string array containing the result set to look like.

Answer 4

thanks it is working