int CountRowsInTable(IDnaDataReader reader, string tableName) { var counts = reader.ExecuteGetInts("c", "select count(*) c from " + tableName); return counts[0]; }
int GetUserIdForSearchTests(IDnaDataReader reader) { string sql = @"select top 1 u.userid" + NL + "FROM Users u WITH(NOLOCK)" + NL + "INNER JOIN Preferences p WITH(NOLOCK) ON p.UserID = u.UserID" + NL + "INNER JOIN Mastheads m WITH(NOLOCK) ON m.UserID = u.UserID AND m.SiteID = p.SiteID" + NL + "INNER JOIN Sites s WITH(NOLOCK) ON s.SiteID = p.SiteID" + NL + "INNER JOIN Userstatuses us WITH(NOLOCK) ON us.UserStatusID = p.PrefStatus" + NL + "INNER JOIN SignInUserIdMapping sm WITH(NOLOCK) ON sm.DnaUserID = u.UserID" + NL + "WHERE s.siteid=1"; return reader.ExecuteGetInts("userid", sql)[0]; }