Unity3d How to connect to a SQL Server database

Although it is possible to save and read data through the Playerprefs class in Unity3d, the workload is very large when the amount of data is increased and access to the data is simply through code. So how do you access data by using a SQL Server database? In fact, the process is also very simple, the process is as follows:

1, find the System.Data.dll file, the default address is in C:Program filesunityeditordatamonolibmonounity, this is based on the path you have installed.

2, copy the file to your workspace under the Asset folder

3. Add references in your editor, I'm using vs

4, add the assembly within the 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 you must use SQL Server and Windows Authentication mode here, or you will get an error

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