System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:e7dcafd2-dd74-4d47-897a-fdf6bda30cba Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90172 AND DataTypeId = 1) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90172,1,'{"status":"ok","response":{"mid":90172,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Jersey Women won by 49 runs","day_remaining_over":"","team_batting":"Isle of Man Women","team_bowling":"Jersey Women","live_inning_number":2,"live_score":{"runs":91,"overs":17.1,"wickets":10,"target":141,"runrate":5.3,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Georgina Ford","batsman_id":149030,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Chloe Greechan","bowler_id":115785,"overs":3.1,"runs_conceded":14,"wickets":1,"maidens":0,"econ":"4.42"},{"name":"Olivia Bastin","bowler_id":145394,"overs":3,"runs_conceded":12,"wickets":0,"maidens":0,"econ":"4"}],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197118,"number":2,"name":"Isle of Man Women inning","short_name":"IM-W inn.","status":2,"issuperover":"false","result":1,"batting_team_id":126803,"fielding_team_id":124545,"scores":"91\/10","scores_full":"91\/10 (17.1 ov)","fielder":[{"fielder_id":"115781","fielder_name":"Trinity Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115778","fielder_name":"Lily Greig","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127561","fielder_name":"Florence Tanguy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115774","fielder_name":"Mia Maguire","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115773","fielder_name":"Grace Wetherall","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Alanya Thorpe","batsman_id":"121374","runs":"9","balls":"15","how_out":"b C Greechan","score_at_dismissal":91,"overs_at_dismissal":"17.1","bowler_id":"115785","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":3,"penalty":"0","total":7},"equations":{"runs":91,"wickets":10,"overs":"17.1","bowlers_used":5,"runrate":"5.30"},"current_partnership":[],"did_not_bat":[],"max_over":"0","target":"141","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"}],"players":[{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":"(C)"},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""}]},"etag":"f4c876af238ce0381d8bd451782fcd55","modified":"2025-06-14 11:07:53","datetime":"2025-06-14 11:07:53","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"mid":90172,"status":2,"status_str":"Completed","game_state":0,"game_state_str":"Default","status_note":"Jersey Women won by 49 runs","day_remaining_over":"","team_batting":"Isle of Man Women","team_bowling":"Jersey Women","live_inning_number":2,"live_score":{"runs":91,"overs":17.1,"wickets":10,"target":141,"runrate":5.3,"required_runrate":""},"commentary":2,"wagon":2,"batsmen":[{"name":"Georgina Ford","batsman_id":149030,"runs":0,"balls_faced":0,"fours":0,"sixes":0,"strike_rate":"0.00"}],"bowlers":[{"name":"Chloe Greechan","bowler_id":115785,"overs":3.1,"runs_conceded":14,"wickets":1,"maidens":0,"econ":"4.42"},{"name":"Olivia Bastin","bowler_id":145394,"overs":3,"runs_conceded":12,"wickets":0,"maidens":0,"econ":"4"}],"commentaries":[],"day":"0","session":"0","live_inning":{"iid":197118,"number":2,"name":"Isle of Man Women inning","short_name":"IM-W inn.","status":2,"issuperover":"false","result":1,"batting_team_id":126803,"fielding_team_id":124545,"scores":"91\/10","scores_full":"91\/10 (17.1 ov)","fielder":[{"fielder_id":"115781","fielder_name":"Trinity Smith","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115778","fielder_name":"Lily Greig","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"127561","fielder_name":"Florence Tanguy","catches":1,"runout_thrower":0,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115774","fielder_name":"Mia Maguire","catches":0,"runout_thrower":1,"runout_catcher":0,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"},{"fielder_id":"115773","fielder_name":"Grace Wetherall","catches":1,"runout_thrower":0,"runout_catcher":1,"runout_direct_hit":0,"stumping":0,"is_substitute":"false"}],"powerplay":[],"review":{"batting":{"batting_team_total_review":"0","batting_team_review_success":"0","batting_team_review_failed":"0","batting_team_review_available":"0","batting_team_review_retained":"0"},"bowling":{"bowling_team_total_review":"0","bowling_team_review_success":"0","bowling_team_review_failed":"0","bowling_team_review_available":"0","bowling_team_review_retained":"0"}},"last_wicket":{"name":"Alanya Thorpe","batsman_id":"121374","runs":"9","balls":"15","how_out":"b C Greechan","score_at_dismissal":91,"overs_at_dismissal":"17.1","bowler_id":"115785","dismissal":"bowled","number":10},"extra_runs":{"byes":0,"legbyes":2,"wides":2,"noballs":3,"penalty":"0","total":7},"equations":{"runs":91,"wickets":10,"overs":"17.1","bowlers_used":5,"runrate":"5.30"},"current_partnership":[],"did_not_bat":[],"max_over":"0","target":"141","recent_scores":[],"last_five_overs":[],"last_ten_overs":[]},"teams":[{"tid":124545,"title":"Jersey Women","abbr":"JER-W","alt_name":"Jersey Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","country":"je","sex":"female","team_owner":"","head_coach":"","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},{"tid":126803,"title":"Isle of Man Women","abbr":"IM-W","alt_name":"Isle of Man Women","type":"country","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","country":"es","sex":"female","team_owner":"","head_coach":"","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"}],"players":[{"pid":115773,"title":"Grace Wetherall","short_name":"G Wetherall","first_name":"Grace Wetherall","last_name":"","middle_name":"","birthdate":"2006-11-11","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115774,"title":"Mia Maguire","short_name":"M Maguire","first_name":"Mia Maguire","last_name":"","middle_name":"","birthdate":"2007-01-16","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":115778,"title":"Lily Greig","short_name":"L Greig","first_name":"Lily Greig","last_name":"","middle_name":"","birthdate":"2005-01-12","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bat","role_str":""},{"pid":115781,"title":"Trinity Smith","short_name":"T Smith","first_name":"Trinity Smith","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"all","role_str":""},{"pid":115782,"title":"Analise Merritt","short_name":"A Merritt","first_name":"Analise Merritt","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"all","role_str":""},{"pid":115785,"title":"Chloe Greechan","short_name":"C Greechan","first_name":"Chloe Greechan","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":"(C)"},{"pid":121369,"title":"Clare Crowe","short_name":"C Crowe","first_name":"Clare Crowe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121371,"title":"Rachel Overman","short_name":"R Overman","first_name":"Rachel Overman","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121372,"title":"Lucy Barnett","short_name":"L Barnett","first_name":"Lucy Barnett","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":121374,"title":"Alanya Thorpe","short_name":"A Thorpe","first_name":"Alanya Thorpe","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bowl","role_str":"(C)"},{"pid":121375,"title":"Ellan Cleator","short_name":"E Cleator","first_name":"Ellan Cleator","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"bat","role_str":""},{"pid":121379,"title":"Catherine Perry","short_name":"C Perry","first_name":"Catherine Perry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":121381,"title":"Danielle Murphy","short_name":"D Murphy","first_name":"Danielle Murphy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""},{"pid":127551,"title":"Aimee Aikenhead","short_name":"A Aikenhead","first_name":"Aimee Aikenhead","last_name":"","middle_name":"","birthdate":"2023-06-22","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":127561,"title":"Florence Tanguy","short_name":"F Tanguy","first_name":"Florence Tanguy","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":129640,"title":"Caitlin Henery","short_name":"C Henery","first_name":"Caitlin Henery","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"gb","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"United Kingdom","role":"all","role_str":""},{"pid":129860,"title":"Rebecca Webster","short_name":"R Webster","first_name":"Rebecca Webster","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"wk","role_str":"(WK)"},{"pid":141793,"title":"Sam Hassall","short_name":"S Hassall","first_name":"Sam Hassall","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"England","role":"bat","role_str":""},{"pid":145394,"title":"Olivia Bastin","short_name":"O Bastin","first_name":"Olivia Bastin","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":148669,"title":"Tallulah Spry","short_name":"T Spry","first_name":"Tallulah Spry","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bat","role_str":""},{"pid":148986,"title":"Annabel Mossop","short_name":"A Mossop","first_name":"Annabel Mossop","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"je","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"Jersey","role":"bowl","role_str":""},{"pid":149030,"title":"Georgina Ford","short_name":"G Ford","first_name":"Georgina Ford","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"int","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","profile_image":"","nationality":"International","role":"bowl","role_str":""}]},"etag":"f4c876af238ce0381d8bd451782fcd55","modified":"2025-06-14 11:07:53","datetime":"2025-06-14 11:07:53","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90172 AND DataTypeId = 1 END

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:30021bba-a7a8-4ddc-91e7-71105d2c0cab Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90172 AND DataTypeId = 3) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90172,3,'{"status":"ok","response":{"match_id":90172,"title":"Isle of Man Women vs Jersey Women","short_title":"IM-W vs JER-W","subtitle":"12th Match","match_number":"11","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Jersey Women won by 49 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"},"teamb":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},"date_start":"2025-05-28 13:00:00","date_end":"2025-05-28 23:00:00","timestamp_start":1748437200,"timestamp_end":1748473200,"date_start_ist":"2025-05-28 18:30:00","date_end_ist":"2025-05-29 04:30:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"JER-W won by 49 runs","result_type":2,"win_margin":"49 runs","winning_team_id":124545,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Isle of Man Women elected to bowl","winner":126803,"decision":2}},"etag":"f45d45c94db51a52a9dc6dc02433edf0","modified":"2025-06-14 11:07:54","datetime":"2025-06-14 11:07:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"match_id":90172,"title":"Isle of Man Women vs Jersey Women","short_title":"IM-W vs JER-W","subtitle":"12th Match","match_number":"11","format":8,"format_str":"Women T20","status":2,"status_str":"Completed","status_note":"Jersey Women won by 49 runs","verified":"false","pre_squad":"false","odds_available":"false","game_state":0,"game_state_str":"Default","competition":{"cid":129599,"title":"ICC Womens T20 World Cup Europe Qualifier Division 2","abbr":"ICC Womens T20 World Cup Europe Qualifier ","type":"tournament","category":"women","match_format":"woment20","season":"2025","status":"live","datestart":"2025-05-25","dateend":"2025-05-29","country":"int","total_matches":"15","total_rounds":"1","total_teams":"6"},"teama":{"team_id":126803,"name":"Isle of Man Women","short_name":"IM-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2023\/07\/Rectangle-3348-2023-07-10T121305.632.png","scores_full":"91\/10 (17.1 ov)","scores":"91\/10","overs":"17.1"},"teamb":{"team_id":124545,"name":"Jersey Women","short_name":"JER-W","logo_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","thumb_url":"https:\/\/gcdnimages.entitysport.com\/assets\/uploads\/2022\/05\/JER-CR1@2x.png","scores_full":"140\/6 (20 ov)","scores":"140\/6","overs":"20"},"date_start":"2025-05-28 13:00:00","date_end":"2025-05-28 23:00:00","timestamp_start":1748437200,"timestamp_end":1748473200,"date_start_ist":"2025-05-28 18:30:00","date_end_ist":"2025-05-29 04:30:00","venue":{"venue_id":"1213565","name":"Simar Cricket Ground","location":"Rome","country":"Italy","timezone":""},"umpires":"Shanaka Fernando (Italy), David McLean (Scotland)","referee":"Graham McCrea (Ireland)","equation":"","live":"","result":"JER-W won by 49 runs","result_type":2,"win_margin":"49 runs","winning_team_id":124545,"commentary":2,"wagon":2,"latest_inning_number":2,"presquad_time":"","verify_time":"","match_dls_affected":"false","live_inning_number":2,"day":"0","session":"0","weather":[],"pitch":{"pitch_condition":"","batting_condition":"Average","pace_bowling_condition":"Average","spine_bowling_condition":"Average"},"toss":{"text":"Isle of Man Women elected to bowl","winner":126803,"decision":2}},"etag":"f45d45c94db51a52a9dc6dc02433edf0","modified":"2025-06-14 11:07:54","datetime":"2025-06-14 11:07:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90172 AND DataTypeId = 3 END
Live Report & Scorecard of Isle of Man Women vs Jersey Women 12th Match