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:c7ea3041-cedb-46e8-adfb-ee3ca5fa6c68 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 43017 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (43017,6,'{"status":"ok","response":{"player":{"pid":43017,"title":"Deandra Dottin","short_name":"DJS Dottin","first_name":"Deandra Dottin","last_name":"","middle_name":"","birthdate":"1991-06-21","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/DeandraDottinCricketer\/","twitter_profile":"https:\/\/twitter.com\/dottin_5","instagram_profile":"https:\/\/www.instagram.com\/worldboss5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":135,"notout":13,"runs":3727,"balls":4712,"highest":150,"run100":3,"run50":22,"run4":398,"run6":89,"average":"30.54","strike":"79.09","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":127,"innings":125,"notout":20,"runs":2697,"balls":0,"highest":112,"run100":2,"run50":12,"run4":0,"run6":0,"average":"25.68","strike":"","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"3","notout":"1","runs":"75","balls":"56","highest":"46","run100":"0","run50":"0","run4":"7","run6":"3","average":"37.50","strike":"133.93","catches":"1","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":94,"balls":2411,"overs":401.5,"runs":1958,"wickets":72,"bestinning":"5\/34","bestmatch":"5\/34","econ":"4.87","average":"27.19","strike":"33.4","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":127,"innings":67,"balls":1111,"overs":185.1,"runs":1190,"wickets":62,"bestinning":"5\/5","bestmatch":"5\/5","econ":"6.42","average":"19.19","strike":"17.9","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"2","balls":"12","overs":"2","runs":"18","wickets":"1","bestinning":"1\/6","bestmatch":"1\/6","econ":"9.00","average":"18.00","strike":"12.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f00d0470c9826359d1d2f532c1f1d337","modified":"2025-06-26 00:43:32","datetime":"2025-06-26 00:43:32","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":43017,"title":"Deandra Dottin","short_name":"DJS Dottin","first_name":"Deandra Dottin","last_name":"","middle_name":"","birthdate":"1991-06-21","birthplace":"Barbados","country":"wi","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/DeandraDottinCricketer\/","twitter_profile":"https:\/\/twitter.com\/dottin_5","instagram_profile":"https:\/\/www.instagram.com\/worldboss5\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"West Indies"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":135,"notout":13,"runs":3727,"balls":4712,"highest":150,"run100":3,"run50":22,"run4":398,"run6":89,"average":"30.54","strike":"79.09","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":127,"innings":125,"notout":20,"runs":2697,"balls":0,"highest":112,"run100":2,"run50":12,"run4":0,"run6":0,"average":"25.68","strike":"","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"3","notout":"1","runs":"75","balls":"56","highest":"46","run100":"0","run50":"0","run4":"7","run6":"3","average":"37.50","strike":"133.93","catches":"1","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":94,"balls":2411,"overs":401.5,"runs":1958,"wickets":72,"bestinning":"5\/34","bestmatch":"5\/34","econ":"4.87","average":"27.19","strike":"33.4","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":127,"innings":67,"balls":1111,"overs":185.1,"runs":1190,"wickets":62,"bestinning":"5\/5","bestmatch":"5\/5","econ":"6.42","average":"19.19","strike":"17.9","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"3","innings":"2","balls":"12","overs":"2","runs":"18","wickets":"1","bestinning":"1\/6","bestmatch":"1\/6","econ":"9.00","average":"18.00","strike":"12.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"f00d0470c9826359d1d2f532c1f1d337","modified":"2025-06-26 00:43:32","datetime":"2025-06-26 00:43:32","api_version":"3.0"}', Modified = GetDate() WHERE Id = 43017 AND DataTypeId = 6 END
Player profile of Deandra Dottin, West Indies
CricDirect Cricket News, Results and Stats
 

Deandra Dottin

NationalityWest Indies
RoleAll Rounder
Born21 Jun 1991 (34)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 143 135 13 3727 150 30.54 4712 79.09 3 22
T20I 127 125 20 2697 112 25.68 - - 2 12

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 143 94 401.5 1958 72 5/34 27.19 4.87 33.4 3 1
T20i 127 67 185.1 1190 62 5/5 19.19 6.42 17.9 1 1
× Close