Pasted

public static List<User> GetUsers()
    {
        ISession session = SessionManager.GetSession();
        List<User> users = new List<User>();
         if (session == null)
            return null;
         string cql = "select * from User";
        RowSet uData = session.Execute(cql);
         if(uData.Count() > 0)
        {
            foreach(Row userData in uData)
            {
                User user = new User();
                user.name = userData["name"] != null ? userData["name"].ToString() : string.Empty;
                user.pass = userData["pass"] != null ? userData["pass"].ToString() : string.Empty;
                user.status = userData["status"] != null ? userData["status"].ToString() : string.Empty;
                users.Add(user);
            }
        }
         return users;
    }