public int WriteChanges(string sqlStr, SqlParameter[] pams = null) { int rowsChanged = 0; using (var conn = SqlConnectionFactory.Create(connType)) { conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = sqlStr; if (pams != null) { cmd.Parameters.AddRange(pams); } rowsChanged = cmd.ExecuteNonQuery(); } return(rowsChanged); }
public T ExecuteReader <T>(string sqlStr, SqlParameter[] pams = null) { using (var conn = SqlConnectionFactory.Create(connType)) { conn.Open(); var cmd = conn.CreateCommand(); cmd.CommandText = sqlStr; if (pams != null) { cmd.Parameters.AddRange(pams); } object obj = cmd.ExecuteReader(); if (obj == null || obj == DBNull.Value) { return(default(T)); } return((T)Convert.ChangeType(obj, typeof(T))); } }
public void InsertBulk(DataTable source, string destinationTbName, List <SqlBulkCopyColumnMapping> mappings = null) { using (var conn = SqlConnectionFactory.Create(connType)) { using (var bulkCopy = new SqlBulkCopy(conn)) { bulkCopy.DestinationTableName = destinationTbName; if (mappings == null) { foreach (DataColumn col in source.Columns) { bulkCopy.ColumnMappings.Add(col.ColumnName, col.ColumnName); } } else { mappings.ForEach(m => bulkCopy.ColumnMappings.Add(m)); } conn.Open(); bulkCopy.WriteToServer(source); } } }