fork download

copy

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using MySql;
using MySql.Data;
using MySql.Data.MySqlClient;
using MySql.Data.Types;
 
namespace MySqlGeoType
{
    class MySqlGear
    {
        private const string conString = "Server = localhost; User Id = root; Password = ****; Database = osm;";
        private MySqlConnection connection { get; set; }
 
        public MySqlGear()
        {
            try
            {
                this.Open();
            }
            catch (Exception exc)
            {
                Console.WriteLine(exc);
            }
        }
 
        internal MySqlConnection Open()
        {
            connection = new MySqlConnection(conString);
            connection.Open();
            if (connection.State == ConnectionState.Open) return connection;
            else return null;
        }
 
        internal MySqlConnection Open(string inputConString)
        {
            if (inputConString != String.Empty) connection = new MySqlConnection(inputConString);
            else connection = new MySqlConnection(conString);
            connection.Open();
            if (connection.State == ConnectionState.Open) return connection;
            else return null;
        }
 
        internal MySqlDataReader SendQuery()
        {
            if (connection.State == ConnectionState.Open)
            {
                MySqlCommand cmd = new MySqlCommand("SELECT AsWKT(object) as 'object' FROM geo.data", connection);
                var reader = cmd.ExecuteReader();
                return reader;
            }
            else return null;
        }
    }
 
    class Program
    {
        static void Main()
        {
            try
            {
                MySqlGear gear = new MySqlGear();
                var reader = gear.SendQuery();
 
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        //var polygon = (byte[])reader["object"];
                        //var obj = new MySqlGeometry(MySqlDbType.Blob, polygon);
                        var polygon = reader["object"].ToString();
                        var obj = MySqlGeometry.Parse(polygon);
                    }
                }
            }
            catch (Exception exc)
            {
                Console.WriteLine(exc);
            }
 
            Console.ReadLine();
        }
    }
}

prog.cs(6,14): error CS0234: The type or namespace name `Data' does not exist in the namespace `System'. Are you missing an assembly reference?
prog.cs(7,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(8,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(9,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(10,7): error CS0246: The type or namespace name `MySql' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(31,18): error CS0246: The type or namespace name `MySqlConnection' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(39,18): error CS0246: The type or namespace name `MySqlConnection' could not be found. Are you missing a using directive or an assembly reference?
prog.cs(48,18): error CS0246: The type or namespace name `MySqlDataReader' could not be found. Are you missing a using directive or an assembly reference?
Compilation failed: 8 error(s), 0 warnings

Standard output is empty