/// <summary> /// Gets the rows total. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="whereClause">The where clause.</param> /// <returns></returns> public int GetRowsTotal <T>(string whereClause = "") where T : new() { int returnValue = 0; SQLiteDataReader reader = null; try { var objectType = typeof(T); var properties = objectType.GetProperties(BindingFlags.Public | BindingFlags.Instance); string sqlQuery = SQLiteQuery.CountTotal(objectType.Name, whereClause); reader = SQLiteQuery.ExecuteReader(sqlQuery, this.Connection); while (reader.Read()) { returnValue = Convert.ToInt32(reader[Constant.TotalCount]); } } catch (Exception exception) { APILog.Error(this, "GetRowsTotal", exception); } finally { reader.Close(); reader = null; } return(returnValue); }