public int InsertUserTeamClassicLeague(UserTeamClassicLeagues classicleagues, SqlConnection db) { try { int rowsAffected = 0; using (IDataReader reader = classicleagues.GetDataReader()) //using (var db = new SqlConnection(ConfigurationManager.ConnectionStrings["FantasyPremierLeagueUserTeam"].ConnectionString)) { //db.Open(); using (var bulkCopy = new SqlBulkCopy(db)) { bulkCopy.BulkCopyTimeout = 1000; bulkCopy.BatchSize = 500; bulkCopy.DestinationTableName = "UserTeamClassicLeague"; bulkCopy.EnableStreaming = true; // Add your column mappings here bulkCopy.ColumnMappings.Add("id", "leagueid"); bulkCopy.ColumnMappings.Add("entry_rank", "entry_rank"); bulkCopy.ColumnMappings.Add("entry_last_rank", "entry_last_rank"); bulkCopy.ColumnMappings.Add("entry_can_leave", "entry_can_leave"); bulkCopy.ColumnMappings.Add("entry_can_admin", "entry_can_admin"); bulkCopy.ColumnMappings.Add("entry_can_invite", "entry_can_invite"); bulkCopy.ColumnMappings.Add("userteamid", "userteamid"); //using (var dataReader = userTeamChips.ToDataReader()) //{ bulkCopy.WriteToServer(reader); rowsAffected = SqlBulkCopyExtension.RowsCopiedCount(bulkCopy); //} } } return(rowsAffected); } catch (Exception ex) { Logger.Error("UserTeamClassicLeague Repository (insert) error: " + ex.Message); throw ex; } }
public int InsertUserTeamClassicLeague(UserTeamClassicLeagues classicleagues, SqlConnection db) { int rowsAffected = 0; try { using (IDataReader reader = classicleagues.GetDataReader()) { using (var bulkCopy = new SqlBulkCopy(db)) { bulkCopy.BulkCopyTimeout = 0; bulkCopy.BatchSize = 500; bulkCopy.DestinationTableName = "UserTeamClassicLeagueStaging"; bulkCopy.EnableStreaming = true; // Add your column mappings here bulkCopy.ColumnMappings.Add("id", "leagueid"); bulkCopy.ColumnMappings.Add("entry_rank", "entry_rank"); bulkCopy.ColumnMappings.Add("entry_last_rank", "entry_last_rank"); bulkCopy.ColumnMappings.Add("entry_can_leave", "entry_can_leave"); bulkCopy.ColumnMappings.Add("entry_can_admin", "entry_can_admin"); bulkCopy.ColumnMappings.Add("entry_can_invite", "entry_can_invite"); bulkCopy.ColumnMappings.Add("userteamid", "userteamid"); bulkCopy.WriteToServer(reader); rowsAffected = SqlBulkCopyExtension.RowsCopiedCount(bulkCopy); } } return(rowsAffected); } catch (Exception ex) { Logger.Error("UserTeamClassicLeague Repository (insert) error: " + ex.Message); return(rowsAffected); //throw ex; } }