Esempi in C# (CSharp) per PetaPoco.Database.Fill

Esempio n. 1

        public static int GetUserTotalCount()
        {
            string sql = "SELECT count(*) as totalcount FROM users u INNER JOIN user_groups g on u.gid=g.gid ";

            using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
            {
                DataSet ds = new DataSet();
                db.Fill(ds, sql);
                try
                {
                    return(Convert.ToInt32(ds.Tables[0].Rows[0]["totalcount"]));
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
        }