private void CreateDatabase() { try { string userDomainName = Environment.UserDomainName; this.databaseServerName = userDomainName.Substring(0, userDomainName.IndexOf("dom", StringComparison.InvariantCultureIgnoreCase)); string connectionString = string.Format("Server={0};Trusted_Connection=Yes;", this.databaseServerName); using (SqlConnection sqlConnection = new SqlConnection(connectionString)) { using (DataContext dataContext = new DataContext(sqlConnection)) { Table <TempDatabase.SysDatabaseTable> table = dataContext.GetTable <TempDatabase.SysDatabaseTable>(); IQueryable <TempDatabase.SysDatabaseTable> source = from db in table where db.Name == "ComplianceJobTempDB" select db; int num = source.Count <TempDatabase.SysDatabaseTable>(); if (num <= 0) { using (TempDatabase.ComplianceJobStore complianceJobStore = new TempDatabase.ComplianceJobStore(sqlConnection)) { complianceJobStore.CreateDatabase(); } } } } } catch (SqlException ex) { throw ex; } }
internal void InsertIntoTable <TTable, TData>(TData data) where TTable : TempDatabase.IComplianceTable <TData>, new() { try { using (SqlConnection sqlConnection = new SqlConnection(this.GetConnectionString())) { using (TempDatabase.ComplianceJobStore complianceJobStore = new TempDatabase.ComplianceJobStore(sqlConnection)) { TTable ttable = (default(TTable) == null) ? Activator.CreateInstance <TTable>() : default(TTable); ttable.SetRowData(data); ttable.InsertRow(complianceJobStore); complianceJobStore.SubmitChanges(); } } } catch (Exception ex) { throw ex; } }
public void InsertRow(TempDatabase.ComplianceJobStore store) { store.Tasks.InsertOnSubmit(this); }