.NET如何访问MySQL数据库

*/  

public string name;
///＜summary＞
/// Table of column if column was a field
///＜/summary＞
public string table;
//public string org_table; /* Org table name if table was an alias */
//public string db; /* Database for table */
///＜summary＞
/// def
///＜/summary＞
public string def;
///＜summary＞
/// length
///＜/summary＞
public long length;
///＜summary＞
/// max_length
///＜/summary＞
public long max_length;
///＜summary＞
/// Div flags
///＜/summary＞
public uint flags;
///＜summary＞
/// Number of decimals in field
///＜/summary＞
public uint decimals;
///＜summary＞
/// Type of field. Se mysql_com.h for types
///＜/summary＞
public uint type;

///＜summary＞
/// Name
///＜/summary＞

public string Name
{
get{return name;}
}
///＜summary＞
/// Type
///＜/summary＞
public uint Type
{
get{return type;}
}
///＜summary＞
/// Max_Length
///＜/summary＞
public long Max_Length
{
get {return max_length;}
}
}

///＜summary＞
/// Field descriptor
///＜/summary＞
[StructLayout(LayoutKind.Sequential)]
internal class MYSQL_FIELD_VERSION_5: IMYSQL_FIELD
{
///＜summary＞
/// Name of column
///＜/summary＞
public string name;
///＜summary＞
/// Original column name, if an alias
///＜/summary＞
public string org_name;
///＜summary＞
/// Table of column if column was a field
///＜/summary＞
public string table;
///＜summary＞
/// Org table name if table was an alias
///＜/summary＞

public string org_table;
///＜summary＞
/// Database for table
///＜/summary＞
public string db;
///＜summary＞
/// Catalog for table
///＜/summary＞
//public string catalog;
///＜summary＞
/// def
///＜/summary＞
public string def;
///＜summary＞
/// length
///＜/summary＞
public long length;
///＜summary＞
/// max_length
///＜/summary＞
public long max_length;
///＜summary＞
/// name_length
///＜/summary＞
//public uint name_length;
///＜summary＞
/// org_name_length
///＜/summary＞
public uint org_name_length;
///＜summary＞
/// table_length
///＜/summary＞
public uint table_length;
///＜summary＞
/// org_table_length
///＜/summary＞
public uint org_table_length;
///＜summary＞
/// db_length
///＜/summary＞

public uint db_length;
///＜summary＞
/// catalog_length
///＜/summary＞
public uint catalog_length;
///＜summary＞
/// def_length
///＜/summary＞
public uint def_length;
///＜summary＞
/// Div flags
///＜/summary＞
public uint flags;
///＜summary＞
/// Number of decimals in field
///＜/summary＞
public uint decimals;
///＜summary＞
/// Character set
///＜/summary＞
public uint charsetnr;
///＜summary＞
/// Type of field. Se mysql_com.h for types
///＜/summary＞
public uint type;

///＜summary＞
/// Name
///＜/summary＞
public string Name
{
get {return name;}
}
///＜summary＞
/// Type
///＜/summary＞
public uint Type
{
get {return type;}
}
///＜summary＞
/// Max_Length
///＜/summary＞
public long Max_Length
{
get {return max_length;}
}
}

//[StructLayout(LayoutKind.Explicit)]
public enum enum_field_types
{
FIELD_TYPE_DECIMAL, FIELD_TYPE_TINY,
FIELD_TYPE_SHORT, FIELD_TYPE_LONG,
FIELD_TYPE_FLOAT, FIELD_TYPE_DOUBLE,
FIELD_TYPE_NULL, FIELD_TYPE_TIMESTAMP,
FIELD_TYPE_LONGLONG,FIELD_TYPE_INT24,
FIELD_TYPE_DATE, FIELD_TYPE_TIME,
FIELD_TYPE_DATETIME, FIELD_TYPE_YEAR,
FIELD_TYPE_NEWDATE,
FIELD_TYPE_ENUM=247,
FIELD_TYPE_SET=248,
FIELD_TYPE_TINY_BLOB=249,
FIELD_TYPE_MEDIUM_BLOB=250,
FIELD_TYPE_LONG_BLOB=251,
FIELD_TYPE_BLOB=252,
FIELD_TYPE_VAR_STRING=253,
FIELD_TYPE_STRING=254,
FIELD_TYPE_GEOMETRY=255

};

///＜summary＞
/// C prototypes warpper for mysqllib.
///＜/summary＞
internal class CPrototypes
{
[ DllImport( "libmySQL.dll", EntryPoint="mysql_init" )]
unsafe public static extern void* mysql_init(void* must_be_null);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_close" )]
unsafe public static extern void mysql_close(void* handle);

// BEGIN ADDITION 2004-07-01 BY Alex Seewald
// Enables us to call mysql_option to activate compression and timeout
[ DllImport( "libmySQL.dll", EntryPoint="mysql_options" )]
unsafe public static extern void mysql_options(void* mysql, uint option, uint *value);
// END ADDITION 2004-07-01 By Alex Seewald

[ DllImport( "libmySQL.dll", EntryPoint="mysql_real_connect" )]
unsafe public static extern void* mysql_real_connect(void* mysql, string host, string user, string passwd, string db, uint port, string unix_socket, int client_flag);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_query" )]
unsafe public static extern int mysql_query(void*mysql, string query);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_store_result" )]
unsafe public static extern void *mysql_store_result(void *mysql);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_free_result" )]
unsafe public static extern void mysql_free_result(void*result);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_errno" )]
unsafe public static extern uint mysql_errno(void*mysql);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_error" )]
unsafe public static extern string mysql_error(void*mysql);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_field_count" )]
unsafe public static extern uint mysql_field_count(void*mysql);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_affected_rows" )]
unsafe public static extern ulong mysql_affected_rows(void*mysql);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_num_fields" )]
unsafe public static extern uint mysql_num_fields(void*result);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_num_rows" )]
unsafe public static extern ulong mysql_num_rows(void *result);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_field_direct" )]
unsafe public static extern IntPtr mysql_fetch_field_direct(void*result, uint fieldnr);

///＜returns＞Returns a string that represents the client library version＜/returns＞
[DllImport("libmySQL.dll",CharSet=System.Runtime.InteropServices.CharSet.Ansi,
EntryPoint="mysql_get_client_info", ExactSpelling=true)]
public static extern string GetClientInfo();

[ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_row" )]
unsafe public static extern IntPtr mysql_fetch_row(void*result);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_select_db" )]
unsafe public static extern int mysql_select_db(void*mysql,string dbname);
[ DllImport( "libmySQL.dll", EntryPoint="mysql_fetch_lengths" )]
unsafe public static extern UInt32 *mysql_fetch_lengths(void*result);

}
}