C# (CSharp) SQLitePCL.sqlite3_stmt.ParseSQLiteLinha Examples

Example #1

        public static IList <IDictionary <string, object> > ExecutarSql(this SQLiteConnection connection, string sqlString)
        {
            var result = new List <IDictionary <string, object> >();

            SQLitePCL.sqlite3_stmt stQuery = null;

            using (connection)
            {
                using (stQuery = SQLite3.Prepare2(connection.Handle, sqlString))
                {
                    var colunas = stQuery.GetColunasSQLite();

                    while (SQLite3.Step(stQuery) == SQLite3.Result.Row)
                    {
                        var linha = stQuery.ParseSQLiteLinha(colunas);

                        result.Add(linha);
                    }
                }
            }

            return(result);
        }