Unity3d How do I connect to a SQL Server database?

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