public static void SubSonicInsert(string name, int score)
{
Data.tbl_Speed_Test st= new Data.tbl_Speed_Test();
st.name = name;
st.score = score;
st.Save();
}
語法超短的，相當於SQL Command的insert into [Died_Test].[dbo].[tbl_Speed_Test] (name,score) values(@name,@score)SubSonic對有預設值的欄位也需要手動對ActiveRecord.cs(如果你是用ActiveRecord)改點設定，詳情可以見這篇"Linq to SQL, Entity Framework, SubSonic 3.0 對於預設欄位的處理方式"。
public static void EntityInsert(string name, int score)
{
tbl_Speed_Test_EF st = new tbl_Speed_Test_EF();
st.name = name;
st.score = score;
using (Died_TestEntities context = new Died_TestEntities())
{
try
{
context.tbl_Speed_Test.AddObject(st);
context.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
}
相當於SQL Command的insert into [Died_Test].[dbo].[tbl_Speed_Test] (name,score) values(@name,@score)Entity Framework對於有預設值的欄位也需要手動對edmx改點設定，詳情可以見這篇"Linq to SQL, Entity Framework, SubSonic 3.0 對於預設欄位的處理方式"。
public static void LinqInsert(string name, int score)
{
LinqModelDataContext DB = new LinqModelDataContext();
tbl_Speed_Test st = new tbl_Speed_Test();
st.name = name;
st.score = score;
DB.tbl_Speed_Tests.InsertOnSubmit(st);
try
{
DB.SubmitChanges();
}
catch(Exception e)
{
throw e;
}
}
這段語法相當於SQL Command的insert into [Died_Test].[dbo].[tbl_Speed_Test] (name,score) values(@name,@score)實際上測試的Table有三個欄位，不過Prime Key的Guid我設成DB自動產生，所以就不塞值進去了，這種方式需要手動對dbml改點設定，詳情可以見這篇"Linq to SQL, Entity Framework, SubSonic 3.0 對於預設欄位的處理方式"。
既然租畫廊作品也賣不掉，那除了畫廊還有別的嗎?
屁股涼颼颼地邊解放邊看作品的可能性探討中!
If we borrow a gallery and cannot sell artwork,
why it have to be at gallery?
Is it possible to see artwork in toilet with naked ass?
