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:f413e5b6-4d02-4c59-a5e6-dd1c71400fd8 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 46131 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (46131,6,'{"status":"ok","response":{"player":{"pid":46131,"title":"Lungisani Ngidi","short_name":"L Ngidi","first_name":"Lungisani Ngidi","last_name":"","middle_name":"","birthdate":"1996-03-29","birthplace":"Durban, Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","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\/NgidiLungi\/","twitter_profile":"https:\/\/twitter.com\/NgidiLungi","instagram_profile":"https:\/\/www.instagram.com\/lungingidi\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":20,"innings":31,"notout":11,"runs":97,"balls":230,"highest":19,"run100":0,"run50":0,"run4":14,"run6":1,"average":"4.85","strike":"42.17","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":67,"innings":27,"notout":16,"runs":124,"balls":236,"highest":20,"run100":0,"run50":0,"run4":8,"run6":6,"average":"11.27","strike":"52.54","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":45,"innings":14,"notout":9,"runs":41,"balls":53,"highest":13,"run100":0,"run50":0,"run4":4,"run6":0,"average":"8.20","strike":"77.35","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":143,"innings":32,"notout":20,"runs":80,"balls":105,"highest":13,"run100":0,"run50":0,"run4":4,"run6":2,"average":"6.66","strike":"76.19","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":94,"innings":38,"notout":23,"runs":170,"balls":297,"highest":20,"run100":0,"run50":0,"run4":13,"run6":6,"average":"11.33","strike":"57.23","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":46,"notout":19,"runs":150,"balls":370,"highest":19,"run100":0,"run50":0,"run4":19,"run6":2,"average":"5.55","strike":"40.54","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"0","notout":"0","runs":"0","balls":"0","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":20,"innings":35,"balls":2578,"overs":429.4,"runs":1356,"wickets":58,"bestinning":"6\/39","bestmatch":"8\/102","econ":"3.15","average":"23.37","strike":"44.4","wicket4i":1,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":67,"innings":66,"balls":3117,"overs":519.3,"runs":3018,"wickets":103,"bestinning":"6\/58","bestmatch":"6\/58","econ":"5.80","average":"29.30","strike":"30.2","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":45,"innings":45,"balls":899,"overs":149.5,"runs":1362,"wickets":65,"bestinning":"5\/39","bestmatch":"5\/39","econ":"9.09","average":"20.95","strike":"13.8","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":143,"innings":140,"balls":2796,"overs":466,"runs":3916,"wickets":185,"bestinning":"5\/39","bestmatch":"5\/39","econ":"8.40","average":"21.16","strike":"15.1","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":94,"innings":92,"balls":4293,"overs":715.3,"runs":4047,"wickets":137,"bestinning":"6\/58","bestmatch":"6\/58","econ":"5.65","average":"29.54","strike":"31.3","wicket4i":5,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":59,"balls":4325,"overs":720.5,"runs":2332,"wickets":97,"bestinning":"6\/37","bestmatch":"9\/82","econ":"3.23","average":"24.04","strike":"44.5","wicket4i":2,"wicket5i":6,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","balls":"18","overs":"3","runs":"43","wickets":"1","bestinning":"1\/27","bestmatch":"1\/27","econ":"14.33","average":"43.00","strike":"18.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"64b0cb5c7da81fe81581dd1e7b895205","modified":"2025-07-18 02:06:23","datetime":"2025-07-18 02:06:23","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":46131,"title":"Lungisani Ngidi","short_name":"L Ngidi","first_name":"Lungisani Ngidi","last_name":"","middle_name":"","birthdate":"1996-03-29","birthplace":"Durban, Natal","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","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\/NgidiLungi\/","twitter_profile":"https:\/\/twitter.com\/NgidiLungi","instagram_profile":"https:\/\/www.instagram.com\/lungingidi\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":20,"innings":31,"notout":11,"runs":97,"balls":230,"highest":19,"run100":0,"run50":0,"run4":14,"run6":1,"average":"4.85","strike":"42.17","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":67,"innings":27,"notout":16,"runs":124,"balls":236,"highest":20,"run100":0,"run50":0,"run4":8,"run6":6,"average":"11.27","strike":"52.54","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":45,"innings":14,"notout":9,"runs":41,"balls":53,"highest":13,"run100":0,"run50":0,"run4":4,"run6":0,"average":"8.20","strike":"77.35","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":143,"innings":32,"notout":20,"runs":80,"balls":105,"highest":13,"run100":0,"run50":0,"run4":4,"run6":2,"average":"6.66","strike":"76.19","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":94,"innings":38,"notout":23,"runs":170,"balls":297,"highest":20,"run100":0,"run50":0,"run4":13,"run6":6,"average":"11.33","strike":"57.23","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":46,"notout":19,"runs":150,"balls":370,"highest":19,"run100":0,"run50":0,"run4":19,"run6":2,"average":"5.55","strike":"40.54","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"0","notout":"0","runs":"0","balls":"0","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":20,"innings":35,"balls":2578,"overs":429.4,"runs":1356,"wickets":58,"bestinning":"6\/39","bestmatch":"8\/102","econ":"3.15","average":"23.37","strike":"44.4","wicket4i":1,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":67,"innings":66,"balls":3117,"overs":519.3,"runs":3018,"wickets":103,"bestinning":"6\/58","bestmatch":"6\/58","econ":"5.80","average":"29.30","strike":"30.2","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":45,"innings":45,"balls":899,"overs":149.5,"runs":1362,"wickets":65,"bestinning":"5\/39","bestmatch":"5\/39","econ":"9.09","average":"20.95","strike":"13.8","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":143,"innings":140,"balls":2796,"overs":466,"runs":3916,"wickets":185,"bestinning":"5\/39","bestmatch":"5\/39","econ":"8.40","average":"21.16","strike":"15.1","wicket4i":5,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":94,"innings":92,"balls":4293,"overs":715.3,"runs":4047,"wickets":137,"bestinning":"6\/58","bestmatch":"6\/58","econ":"5.65","average":"29.54","strike":"31.3","wicket4i":5,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":59,"balls":4325,"overs":720.5,"runs":2332,"wickets":97,"bestinning":"6\/37","bestmatch":"9\/82","econ":"3.23","average":"24.04","strike":"44.5","wicket4i":2,"wicket5i":6,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","balls":"18","overs":"3","runs":"43","wickets":"1","bestinning":"1\/27","bestmatch":"1\/27","econ":"14.33","average":"43.00","strike":"18.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"64b0cb5c7da81fe81581dd1e7b895205","modified":"2025-07-18 02:06:23","datetime":"2025-07-18 02:06:23","api_version":"3.0"}', Modified = GetDate() WHERE Id = 46131 AND DataTypeId = 6 END
Player profile of Lungisani Ngidi, South Africa
CricDirect Cricket News, Results and Stats
 

Lungisani Ngidi

NationalitySouth Africa
RoleBowler
Born29 Mar 1996 (29)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 20 31 11 97 19 4.85 230 42.17 - -
ODI 67 27 16 124 20 11.27 236 52.54 - -
T20I 45 14 9 41 13 8.20 53 77.35 - -
T20I 143 32 20 80 13 6.66 105 76.19 - -
List A 94 38 23 170 20 11.33 297 57.23 - -
1st Class 34 46 19 150 19 5.55 370 40.54 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 20 35 429.4 1356 58 6/39 23.37 3.15 44.4 1 3
ODI 67 66 519.3 3018 103 6/58 29.30 5.80 30.2 4 1
T20i 45 45 149.5 1362 65 5/39 20.95 9.09 13.8 2 1
T20 143 140 466 3916 185 5/39 21.16 8.40 15.1 5 1
List A 94 92 715.3 4047 137 6/58 29.54 5.65 31.3 5 2
1st Class 34 59 720.5 2332 97 6/37 24.04 3.23 44.5 2 6
× Close