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:9c15f961-dd3e-49c0-8e2b-0d0547190697
Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1975 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1975,6,'{"status":"ok","response":{"player":{"pid":1975,"title":"Ashley Nurse","short_name":"A Nurse","first_name":"Ashley Nurse","last_name":"","middle_name":"","birthdate":"1988-12-22","birthplace":"Gibbons, Christ Church, Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/skins_05","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":54,"innings":40,"notout":14,"runs":502,"balls":513,"highest":44,"run100":0,"run50":0,"run4":44,"run6":12,"average":"19.30","strike":"97.85","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":8,"notout":6,"runs":85,"balls":71,"highest":20,"run100":0,"run50":0,"run4":7,"run6":3,"average":"42.50","strike":"119.71","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":79,"notout":40,"runs":715,"balls":611,"highest":40,"run100":0,"run50":0,"run4":43,"run6":35,"average":"18.33","strike":"117.02","catches":42,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":91,"notout":30,"runs":1077,"balls":0,"highest":57,"run100":0,"run50":1,"run4":0,"run6":0,"average":"17.65","strike":"","catches":62,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":52,"innings":72,"notout":9,"runs":1373,"balls":2005,"highest":130,"run100":1,"run50":4,"run4":142,"run6":39,"average":"21.79","strike":"68.47","catches":82,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"44","innings":"36","notout":"9","runs":"622","balls":"338","highest":"62","run100":"0","run50":"1","run4":"43","run6":"48","average":"23.04","strike":"184.02","catches":"17","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":54,"innings":49,"balls":2384,"overs":397.2,"runs":2125,"wickets":49,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.34","average":"43.36","strike":"48.6","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":13,"balls":240,"overs":40,"runs":318,"wickets":8,"bestinning":"2\/6","bestmatch":"2\/6","econ":"7.95","average":"39.75","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":92,"balls":1572,"overs":262,"runs":1870,"wickets":77,"bestinning":"5\/26","bestmatch":"5\/26","econ":"7.13","average":"24.28","strike":"20.4","wicket4i":1,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":111,"balls":5298,"overs":883,"runs":4237,"wickets":154,"bestinning":"6\/29","bestmatch":"6\/29","econ":"4.79","average":"27.51","strike":"34.4","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":52,"innings":86,"balls":7741,"overs":1290.1,"runs":3902,"wickets":162,"bestinning":"7\/10","bestmatch":"14\/40","econ":"3.02","average":"24.08","strike":"47.7","wicket4i":10,"wicket5i":4,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"44","innings":"13","balls":"119","overs":"19.5","runs":"221","wickets":"13","bestinning":"2\/13","bestmatch":"2\/13","econ":"11.14","average":"17.00","strike":"9.15","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"ac42d03f23a8926df2c60e867fbc5c36","modified":"2025-06-26 11:46:58","datetime":"2025-06-26 11:46:58","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1975,"title":"Ashley Nurse","short_name":"A Nurse","first_name":"Ashley Nurse","last_name":"","middle_name":"","birthdate":"1988-12-22","birthplace":"Gibbons, Christ Church, Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/skins_05","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":54,"innings":40,"notout":14,"runs":502,"balls":513,"highest":44,"run100":0,"run50":0,"run4":44,"run6":12,"average":"19.30","strike":"97.85","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":8,"notout":6,"runs":85,"balls":71,"highest":20,"run100":0,"run50":0,"run4":7,"run6":3,"average":"42.50","strike":"119.71","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":79,"notout":40,"runs":715,"balls":611,"highest":40,"run100":0,"run50":0,"run4":43,"run6":35,"average":"18.33","strike":"117.02","catches":42,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":91,"notout":30,"runs":1077,"balls":0,"highest":57,"run100":0,"run50":1,"run4":0,"run6":0,"average":"17.65","strike":"","catches":62,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":52,"innings":72,"notout":9,"runs":1373,"balls":2005,"highest":130,"run100":1,"run50":4,"run4":142,"run6":39,"average":"21.79","strike":"68.47","catches":82,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"44","innings":"36","notout":"9","runs":"622","balls":"338","highest":"62","run100":"0","run50":"1","run4":"43","run6":"48","average":"23.04","strike":"184.02","catches":"17","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":54,"innings":49,"balls":2384,"overs":397.2,"runs":2125,"wickets":49,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.34","average":"43.36","strike":"48.6","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":13,"innings":13,"balls":240,"overs":40,"runs":318,"wickets":8,"bestinning":"2\/6","bestmatch":"2\/6","econ":"7.95","average":"39.75","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":112,"innings":92,"balls":1572,"overs":262,"runs":1870,"wickets":77,"bestinning":"5\/26","bestmatch":"5\/26","econ":"7.13","average":"24.28","strike":"20.4","wicket4i":1,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":111,"balls":5298,"overs":883,"runs":4237,"wickets":154,"bestinning":"6\/29","bestmatch":"6\/29","econ":"4.79","average":"27.51","strike":"34.4","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":52,"innings":86,"balls":7741,"overs":1290.1,"runs":3902,"wickets":162,"bestinning":"7\/10","bestmatch":"14\/40","econ":"3.02","average":"24.08","strike":"47.7","wicket4i":10,"wicket5i":4,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"44","innings":"13","balls":"119","overs":"19.5","runs":"221","wickets":"13","bestinning":"2\/13","bestmatch":"2\/13","econ":"11.14","average":"17.00","strike":"9.15","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"ac42d03f23a8926df2c60e867fbc5c36","modified":"2025-06-26 11:46:58","datetime":"2025-06-26 11:46:58","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1975 AND DataTypeId = 6 END Player profile of Ashley Nurse, West Indies
