I. Overview
Not long ago there was a buddy doing PC game development. Use to Unity3d,
Just found me.
I offered him a way to unity3d how to Moon.orm to intelligently program.
Let's take a look at how to make sqlite more convenient.
Http://www.cnblogs.com/humble/p/4593133.html
usingSystem;usingMoon_sqlite;usingMoon.orm;usingMoon.Orm.Util;namespacetestsome{classProgram { Public Static voidMain (string[] args) { //Add Data using(Var db=new sqlite ("SQLite's link string")) { /*clears the data table db. Remove<scoreset> (); Db. Remove<studentset> (); Db. Remove<classset> (); */ //Add DataClass cl=NewClass (); All ClassName="class"+DateTime.Now.ToString (); All Classlevel=1; Db. ADD (CL); Console.WriteLine ("add [Class] success, id={0}", cl.id); Student Stu=NewStudent (); Stu. Age= A; Stu. BirthDay=DateTime.Now; Stu. class_id=cl.id; Stu. Name="Zhang San"+DateTime.Now; Stu. Sex=true; Db. ADD (Stu); Console.WriteLine ("add [Student] success, id={0}", stu.id); Score SCO=Newscore (); Sco. Score_=98; Sco. student_id=stu.id; Db. ADD (SCO); Console.WriteLine ("Add [score] success, id={0}", stu.id); //with new dataScore update=Newscore (); Update. Score_= -; Update. Whereexpression=ScoreSet.ID.Equal (sco.id); Db. Update (update); } //Querying Data using(vardb=Db.createdefaultdb ()) { //Connection Query varmqljoin=Scoreset.selectall (). Innerjoin (Studentset.select (Studentset.name)). Innerjoin (Classset.select (ClassSet.ID.AS ("ClassID") , Classset.classname). On (scoreset.student_id. Equal (studentset.id). and (studentset.class_id. Equal (classset.id)); //View current SQL varSql=Mqljoin.todebugsql (); varlist=db. Getdictionarylist (Mqljoin); //Show Datalist. Showinconsole (); //let's not need entity classes stringSql2=Mqljoin.toparameterssql (); DynamicDlist=db. Getdynamiclist (SQL2,"Custom class name"); foreach(DynamicEntityinchdlist) {Console.WriteLine (entity.id+" "+entity. Score+" "+entity. Student_id+" "+entity. name+" "+entity. Classid+" "+entity. ClassName); } //Get entity set varEntitylist=db. Getentities<score> (Scoreset.selectall (). Where (ScoreSet.ID.BiggerThan (0))); } console.write ("Press any key to continue ..."); Console.readkey (true); } }}
Second, how to use in Unity3d.
1. Download Moon.orm
:
Http://lko2o.com/moon/article/3
2. Quoting Moon.orm.dll
3. Place the library to the following location
Put Moon.orm.dll, System.Data.SQLite.dll, SQLite.Interop.dll SQLite database files into the Unity3d editor EXE location;
The query results can be seen directly in the editor.
Note: As well as in the final target program there is also a copy. (after build and then put)
4. Using the code generator
This link describes how to use the code generator: http://www.cnblogs.com/humble/p/4593133.html
5. Start coding
using (var db=New SQLite ("SQLite's link string ")) { var mql= Userset.select (Userset.name). Where (UserSet.ID.Equal (9)); var name=Db. Getscale (MQL). ToString ();}
Unity3d free and easy to use database processing Framework Database Direct connection Framework