在LINQ下直接執行SQL語法

Dim _ctx As MyDBContext
_ctx = New MyDBContext(ConfigurationManager.AppSettings("連線字串"))


1.
_ctx.Database.ExecuteSqlCommand("truncate table 人事檔")


2.
_ctx.Database.ExecuteSqlCommand("delete from 人事檔 where counter=1")