petapoco mysql_PetaPoco与SQLite

(1)==数据库配置文件

(2)配置类classConfig

{public static string DatabaseFile = "";public static stringDataSource

{get{return string.Format("data source={0}", ConfigurationManager.AppSettings["SQLString2"]);

}

}

}

(3)==BaseServices类usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.SQLite;usingSystem.Linq;usingSystem.Runtime.Remoting.Messaging;usingSystem.Text;usingApp.Core.Constant;usingPetaPoco;namespaceApp.Core.Service

{public abstract classBaseService

{privateIDbConnection connection;publicBaseService()

{

connection= newSQLiteConnection(Config.DataSource);

}///

///查询所有对象///

/// 泛型对象

///

public List Query()

{var list = new List();try{string className = typeof(T).ToString();var db = newDatabase(connection);string name =className.Substring(

className.LastIndexOf('.') + 1,

className.Length- className.LastIndexOf('.') - 1);

connection.Open();

list= db.Fetch(string.Format("select * from {0}", name));

}catch(Exception ex)

{throwex;

}returnlist;

}///

///删除对象///

/// 泛型对象

///

///

public int Delete(objectobjData)

{var result = 0;try{var db = newDatabase(connection);

connection.Open();

result= db.Delete(objData);

}catch(Exception ex)

{throwex;

}returnresult;

}///

///添加一条记录///

///

///

///

public T Add(objectobjData)

{

T result;try{var db = newDatabase(connection);

connection.Open();

result= (T)Convert.ChangeType(db.Insert(objData), typeof(T));

}catch(Exception ex)

{throwex;

}returnresult;

}

}

}