1, find the System.Data.dll file, the default address is in C:\Program files\unity\editor\data\mono\lib\mono\unity, which depends on the path you installed.
2. Copy the file to the asset folder in your workspace
3. Add references in your editor, I use vs
4. Add an assembly within a namespace
Using System;
Using System.Data;
Using System.Data.SqlClient;
5, write the connection database code
SqlConnection con = null;
SqlDataAdapter SDA = null;
void Start ()
{
string s = @ "server=.; database=connecttest;uid=sa;pwd=123456 "; Note that SQL Server and Windows Authentication mode must be used here, or the error will be
con = new SqlConnection (s);
Con. Open ();
String sql = "SELECT * FROM table1";
SDA = new SqlDataAdapter (sql, con);
DataSet ds = new DataSet ();
Sda. Fill (ds, "Table1");
Print (ds. Tables[0]. Rows[0][0]);
}
6. Experimental results