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:e777d185-d541-4f91-bff5-e2272aab5f9a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 47496 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (47496,6,'{"status":"ok","response":{"player":{"pid":47496,"title":"Prenelan Subrayen","short_name":"P Subrayen","first_name":"Prenelan Subrayen","last_name":"","middle_name":"","birthdate":"1993-09-23","birthplace":"Tongaat, Durban","country":"za","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Prene13","instagram_profile":"https:\/\/www.instagram.com\/prenelan_subrayen13\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":54,"notout":25,"runs":492,"balls":399,"highest":35,"run100":0,"run50":0,"run4":21,"run6":28,"average":"16.96","strike":"123.30","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":101,"innings":64,"notout":19,"runs":933,"balls":1146,"highest":86,"run100":0,"run50":3,"run4":73,"run6":20,"average":"20.73","strike":"81.41","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":77,"innings":100,"notout":15,"runs":1595,"balls":2986,"highest":134,"run100":1,"run50":7,"run4":163,"run6":47,"average":"18.76","strike":"53.41","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":114,"balls":2338,"overs":389.4,"runs":2547,"wickets":110,"bestinning":"4\/22","bestmatch":"4\/22","econ":"6.53","average":"23.15","strike":"21.2","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":101,"innings":93,"balls":4349,"overs":724.5,"runs":3365,"wickets":96,"bestinning":"4\/46","bestmatch":"4\/46","econ":"4.64","average":"35.05","strike":"45.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":77,"innings":120,"balls":15161,"overs":2526.5,"runs":6762,"wickets":242,"bestinning":"7\/52","bestmatch":"11\/97","econ":"2.67","average":"27.94","strike":"62.6","wicket4i":10,"wicket5i":12,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"093bb542663bf48a2487aee183ce127f","modified":"2025-06-22 06:51:34","datetime":"2025-06-22 06:51:34","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":47496,"title":"Prenelan Subrayen","short_name":"P Subrayen","first_name":"Prenelan Subrayen","last_name":"","middle_name":"","birthdate":"1993-09-23","birthplace":"Tongaat, Durban","country":"za","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,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Prene13","instagram_profile":"https:\/\/www.instagram.com\/prenelan_subrayen13\/","debut_data":"","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":54,"notout":25,"runs":492,"balls":399,"highest":35,"run100":0,"run50":0,"run4":21,"run6":28,"average":"16.96","strike":"123.30","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":101,"innings":64,"notout":19,"runs":933,"balls":1146,"highest":86,"run100":0,"run50":3,"run4":73,"run6":20,"average":"20.73","strike":"81.41","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":77,"innings":100,"notout":15,"runs":1595,"balls":2986,"highest":134,"run100":1,"run50":7,"run4":163,"run6":47,"average":"18.76","strike":"53.41","catches":39,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":120,"innings":114,"balls":2338,"overs":389.4,"runs":2547,"wickets":110,"bestinning":"4\/22","bestmatch":"4\/22","econ":"6.53","average":"23.15","strike":"21.2","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":101,"innings":93,"balls":4349,"overs":724.5,"runs":3365,"wickets":96,"bestinning":"4\/46","bestmatch":"4\/46","econ":"4.64","average":"35.05","strike":"45.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":77,"innings":120,"balls":15161,"overs":2526.5,"runs":6762,"wickets":242,"bestinning":"7\/52","bestmatch":"11\/97","econ":"2.67","average":"27.94","strike":"62.6","wicket4i":10,"wicket5i":12,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"093bb542663bf48a2487aee183ce127f","modified":"2025-06-22 06:51:34","datetime":"2025-06-22 06:51:34","api_version":"3.0"}', Modified = GetDate() WHERE Id = 47496 AND DataTypeId = 6 END
Player profile of Prenelan Subrayen, South Africa
CricDirect Cricket News, Results and Stats
 

Prenelan Subrayen

NationalitySouth Africa
RoleAll Rounder
Born23 Sep 1993 (31)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 120 54 25 492 35 16.96 399 123.30 - -
List A 101 64 19 933 86 20.73 1146 81.41 - 3
1st Class 77 100 15 1595 134 18.76 2986 53.41 1 7

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 120 114 389.4 2547 110 4/22 23.15 6.53 21.2 2 -
List A 101 93 724.5 3365 96 4/46 35.05 4.64 45.3 1 -
1st Class 77 120 2526.5 6762 242 7/52 27.94 2.67 62.6 10 12
× Close