public static void InsertOperationLog(string operation, string query, string program) { var username = System.Security.Principal.WindowsIdentity.GetCurrent().Name; var pcname = System.Environment.MachineName; using (var context = new System.Data.Linq.DataContext(Central.SpecialConnStr)) { context.ExecuteCommand("insert into log (id,username,computername,logdate,operation,queryon,program)" + " values ({0},{1},{2},{3},{4},{5},{6})", Guid.NewGuid(), username, pcname, DateTime.Now.Subtract(MinimalDate).Ticks, operation, query, program); } }
public override bool Ping(DataContext dataContext) { var result = dataContext.ExecuteCommand("SELECT 11 FROM DUAL"); if (result is decimal) { return((int)(decimal)result == 11); } else { return((int)result == 11); } }
public void DeleteAll() { using (PersonsDBEntities pb = conn.GetContext()) { System.Configuration.ConnectionStringSettingsCollection connectionStrings = WebConfigurationManager.ConnectionStrings as ConnectionStringSettingsCollection; if (connectionStrings.Count > 0) { System.Data.Linq.DataContext db = new System.Data.Linq.DataContext(connectionStrings["ConnectionString"].ConnectionString); db.ExecuteCommand("TRUNCATE TABLE TelContact"); } } }
public override bool Ping(DataContext dataContext) { return dataContext.ExecuteCommand("SELECT 11 FROM DUAL") == 11; }
public override bool Ping(DataContext dataContext) { return(dataContext.ExecuteCommand("SELECT 11 FROM DUAL") == 11); }
public int ExecuteCommand(string command, params object[] parameters) { return(_linqContext.ExecuteCommand(command, parameters)); }