Esempio n. 1
0
            public int GetRowCount(string table, params WhereClause[] whereClauses)
            {
                var sql = new SelectQueryBuilder();

                sql.SelectColumn("*");
                sql.SelectFromTable(table);
                whereClauses.ForEach(w => sql.AddWhere(w));

                DataTable executeDataTable
                    = SimpleDataAccess.ExecuteDataTable(cmd => {
                    cmd.CommandType = CommandType.Text;
                    cmd.CommandText = sql.BuildQuery();
                },
                                                        Connection);

                return(executeDataTable.Rows.Count);
            }