public void _14_ScriptTest() { DBParam pname = DBParam.ParamWithDelegate(delegate { return("My Customer Name"); }); DBParam paddress = DBParam.ParamWithDelegate(delegate { return("My Customer Address"); }); DBQuery q = DBQuery.Begin( DBQuery.InsertInto("CUSOMERS").Fields("customer_name", "customer_address") .Values(pname, paddress), DBQuery.Select(DBFunction.LastID())) .End(); q = SerializeAndDeserialzeQueryToMatch(q, "Simple Script"); }
public void Test_04_InsertScript() { byte[] imgdata = this.GetLocalImage("bomb.gif"); DBParam cName = DBParam.ParamWithValue("name", DbType.String, (object)"newType_1"); DBParam cDesc = DBParam.ParamWithValue("desc", DbType.String, (object)"newDescrption_1"); DBParam cPic = DBParam.ParamWithValue("pic", DbType.Binary, (object)imgdata); DBInsertQuery ins = DBQuery.InsertInto("Categories") .Fields("CategoryName", "Description", "Picture") .Values(cName, cDesc, cPic); DBSelectQuery sel = DBQuery.Select(DBFunction.LastID()); DBScript script = DBQuery.Begin(ins) .Then(sel) .End(); this.OutputSql(script, "Insert and Return last ID script"); this.OutputXML(script, "Insert and Return last ID script"); }