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:2777b016-6e45-456a-82d5-75ea0182cfea Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 47483 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (47483,6,'{"status":"ok","response":{"player":{"pid":47483,"title":"George Linde","short_name":"GF Linde","first_name":"George Linde","last_name":"","middle_name":"","birthdate":"1991-12-04","birthplace":"Cape Town","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gflinde","instagram_profile":"https:\/\/www.instagram.com\/george_linde\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":0,"runs":135,"balls":255,"highest":37,"run100":0,"run50":0,"run4":19,"run6":2,"average":"22.50","strike":"52.94","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":27,"balls":29,"highest":18,"run100":0,"run50":0,"run4":3,"run6":0,"average":"27.00","strike":"93.10","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":16,"innings":12,"notout":1,"runs":159,"balls":109,"highest":48,"run100":0,"run50":0,"run4":9,"run6":10,"average":"14.45","strike":"145.87","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":206,"innings":157,"notout":42,"runs":2285,"balls":1683,"highest":66,"run100":0,"run50":4,"run4":137,"run6":115,"average":"19.86","strike":"135.76","catches":54,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":80,"notout":14,"runs":1880,"balls":1874,"highest":93,"run100":0,"run50":14,"run4":136,"run6":57,"average":"28.48","strike":"100.32","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":117,"notout":11,"runs":3650,"balls":5664,"highest":152,"run100":6,"run50":20,"run4":424,"run6":68,"average":"34.43","strike":"64.44","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"20","innings":"12","notout":"5","runs":"115","balls":"67","highest":"31","run100":"0","run50":"0","run4":"11","run6":"7","average":"16.43","strike":"171.64","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":5,"balls":473,"overs":78.5,"runs":252,"wickets":9,"bestinning":"5\/64","bestmatch":"5\/68","econ":"3.19","average":"28.00","strike":"52.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":90,"overs":15,"runs":72,"wickets":3,"bestinning":"2\/32","bestmatch":"2\/32","econ":"4.80","average":"24.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":336,"overs":56,"runs":389,"wickets":20,"bestinning":"4\/21","bestmatch":"4\/21","econ":"6.94","average":"19.45","strike":"16.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":206,"innings":195,"balls":3881,"overs":646.5,"runs":4803,"wickets":186,"bestinning":"4\/19","bestmatch":"4\/19","econ":"7.42","average":"25.82","strike":"20.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":88,"balls":4135,"overs":689.1,"runs":3591,"wickets":118,"bestinning":"6\/47","bestmatch":"6\/47","econ":"5.21","average":"30.43","strike":"35.0","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":136,"balls":14198,"overs":2366.2,"runs":6955,"wickets":254,"bestinning":"7\/29","bestmatch":"11\/131","econ":"2.93","average":"27.38","strike":"55.8","wicket4i":9,"wicket5i":15,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"20","innings":"11","balls":"108","overs":"18","runs":"202","wickets":"14","bestinning":"2\/18","bestmatch":"2\/18","econ":"11.22","average":"14.43","strike":"7.71","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"c574a7d135ea0ebdf11a5dcf4ac1c5cd","modified":"2025-06-26 14:05:49","datetime":"2025-06-26 14:05:49","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":47483,"title":"George Linde","short_name":"GF Linde","first_name":"George Linde","last_name":"","middle_name":"","birthdate":"1991-12-04","birthplace":"Cape Town","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/gflinde","instagram_profile":"https:\/\/www.instagram.com\/george_linde\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":0,"runs":135,"balls":255,"highest":37,"run100":0,"run50":0,"run4":19,"run6":2,"average":"22.50","strike":"52.94","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"notout":1,"runs":27,"balls":29,"highest":18,"run100":0,"run50":0,"run4":3,"run6":0,"average":"27.00","strike":"93.10","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":16,"innings":12,"notout":1,"runs":159,"balls":109,"highest":48,"run100":0,"run50":0,"run4":9,"run6":10,"average":"14.45","strike":"145.87","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":206,"innings":157,"notout":42,"runs":2285,"balls":1683,"highest":66,"run100":0,"run50":4,"run4":137,"run6":115,"average":"19.86","strike":"135.76","catches":54,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":80,"notout":14,"runs":1880,"balls":1874,"highest":93,"run100":0,"run50":14,"run4":136,"run6":57,"average":"28.48","strike":"100.32","catches":35,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":117,"notout":11,"runs":3650,"balls":5664,"highest":152,"run100":6,"run50":20,"run4":424,"run6":68,"average":"34.43","strike":"64.44","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"20","innings":"12","notout":"5","runs":"115","balls":"67","highest":"31","run100":"0","run50":"0","run4":"11","run6":"7","average":"16.43","strike":"171.64","catches":"4","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":5,"balls":473,"overs":78.5,"runs":252,"wickets":9,"bestinning":"5\/64","bestmatch":"5\/68","econ":"3.19","average":"28.00","strike":"52.5","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":2,"innings":2,"balls":90,"overs":15,"runs":72,"wickets":3,"bestinning":"2\/32","bestmatch":"2\/32","econ":"4.80","average":"24.00","strike":"30.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":336,"overs":56,"runs":389,"wickets":20,"bestinning":"4\/21","bestmatch":"4\/21","econ":"6.94","average":"19.45","strike":"16.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":206,"innings":195,"balls":3881,"overs":646.5,"runs":4803,"wickets":186,"bestinning":"4\/19","bestmatch":"4\/19","econ":"7.42","average":"25.82","strike":"20.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":90,"innings":88,"balls":4135,"overs":689.1,"runs":3591,"wickets":118,"bestinning":"6\/47","bestmatch":"6\/47","econ":"5.21","average":"30.43","strike":"35.0","wicket4i":3,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":136,"balls":14198,"overs":2366.2,"runs":6955,"wickets":254,"bestinning":"7\/29","bestmatch":"11\/131","econ":"2.93","average":"27.38","strike":"55.8","wicket4i":9,"wicket5i":15,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"20","innings":"11","balls":"108","overs":"18","runs":"202","wickets":"14","bestinning":"2\/18","bestmatch":"2\/18","econ":"11.22","average":"14.43","strike":"7.71","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"c574a7d135ea0ebdf11a5dcf4ac1c5cd","modified":"2025-06-26 14:05:49","datetime":"2025-06-26 14:05:49","api_version":"3.0"}', Modified = GetDate() WHERE Id = 47483 AND DataTypeId = 6 END
Player profile of George Linde, South Africa
<>
CricDirect Cricket News, Results and Stats
 

George Linde

NationalitySouth Africa
RoleAll Rounder
Born04 Dec 1991 (33)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 3 6 - 135 37 22.50 255 52.94 - -
ODI 2 2 1 27 18 27.00 29 93.10 - -
T20I 16 12 1 159 48 14.45 109 145.87 - -
T20I 206 157 42 2285 66 19.86 1683 135.76 - 4
List A 90 80 14 1880 93 28.48 1874 100.32 - 14
1st Class 81 117 11 3650 152 34.43 5664 64.44 6 20

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 3 5 78.5 252 9 5/64 28.00 3.19 52.5 1 1
ODI 2 2 15 72 3 2/32 24.00 4.80 30.0 - -
T20i 16 16 56 389 20 4/21 19.45 6.94 16.8 1 -
T20 206 195 646.5 4803 186 4/19 25.82 7.42 20.8 4 -
List A 90 88 689.1 3591 118 6/47 30.43 5.21 35.0 3 2
1st Class 81 136 2366.2 6955 254 7/29 27.38 2.93 55.8 9 15
× Close