public static Character GetCharacter(string characterName)
        {
            IDbDataParameter parameter = WebSite.Database.CreateParameter("@Name", characterName);
            DataTable        table     = WebSite.Database.ExecuteQuery("SELECT * FROM characters WHERE Name=@Name", parameter);

            if (table == null)
            {
                return(null);
            }

            if (table.Rows.Count < 1)
            {
                return(null);
            }

            DataRow dataRow = table.Rows[0];

            return(CharacterHelper.FromDataRow(dataRow));
        }
        public static Character GetCharacter(int id)
        {
            if (id == -1)
            {
                return(null);
            }

            IDbDataParameter parameter = WebSite.Database.CreateParameter("@ID", id);
            DataTable        table     = WebSite.Database.ExecuteQuery("SELECT * FROM characters WHERE Id=@ID", parameter);

            if (table == null)
            {
                return(null);
            }

            if (table.Rows.Count < 1)
            {
                return(null);
            }

            DataRow dataRow = table.Rows[0];

            return(CharacterHelper.FromDataRow(dataRow));
        }
        public static Character[] GetCharacters(User user)
        {
            IDbDataParameter parameter = WebSite.Database.CreateParameter("@UserId", user.Id);
            DataTable        table     = WebSite.Database.ExecuteQuery("SELECT * FROM characters WHERE UserId=@UserId", parameter);

            if (table == null)
            {
                return(new Character[0]);
            }

            if (table.Rows.Count < 1)
            {
                return(new Character[0]);
            }

            List <Character> characters = new List <Character>();

            foreach (DataRow row in table.Rows)
            {
                characters.Add(CharacterHelper.FromDataRow(row));
            }

            return(characters.ToArray());
        }