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:49c286f6-92d0-4bb8-84d9-31cf99b278a8 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90789 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90789,6,'{"status":"ok","response":{"player":{"pid":90789,"title":"Prayash Singh","short_name":"Prayash Singh","first_name":"Prayash Singh","last_name":"","middle_name":"","birthdate":"1994-02-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"notout":3,"runs":175,"balls":142,"highest":75,"run100":0,"run50":1,"run4":15,"run6":7,"average":"14.58","strike":"123.23","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"notout":3,"runs":267,"balls":256,"highest":51,"run100":0,"run50":2,"run4":14,"run6":18,"average":"15.70","strike":"104.29","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":11,"notout":0,"runs":294,"balls":502,"highest":104,"run100":1,"run50":1,"run4":40,"run6":6,"average":"26.72","strike":"58.56","catches":4,"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":17,"innings":12,"balls":126,"overs":21,"runs":165,"wickets":5,"bestinning":"3\/6","bestmatch":"3\/6","econ":"7.85","average":"33.00","strike":"25.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"balls":647,"overs":107.5,"runs":595,"wickets":22,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.51","average":"27.04","strike":"29.4","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":13,"balls":833,"overs":138.5,"runs":552,"wickets":11,"bestinning":"3\/66","bestmatch":"3\/119","econ":"3.97","average":"50.18","strike":"75.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"ada17d1073d51b67bdacc2ec9ee7dd5a","modified":"2025-06-19 08:45:54","datetime":"2025-06-19 08:45:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":90789,"title":"Prayash Singh","short_name":"Prayash Singh","first_name":"Prayash Singh","last_name":"","middle_name":"","birthdate":"1994-02-02","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"notout":3,"runs":175,"balls":142,"highest":75,"run100":0,"run50":1,"run4":15,"run6":7,"average":"14.58","strike":"123.23","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"notout":3,"runs":267,"balls":256,"highest":51,"run100":0,"run50":2,"run4":14,"run6":18,"average":"15.70","strike":"104.29","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":11,"notout":0,"runs":294,"balls":502,"highest":104,"run100":1,"run50":1,"run4":40,"run6":6,"average":"26.72","strike":"58.56","catches":4,"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":17,"innings":12,"balls":126,"overs":21,"runs":165,"wickets":5,"bestinning":"3\/6","bestmatch":"3\/6","econ":"7.85","average":"33.00","strike":"25.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":25,"innings":20,"balls":647,"overs":107.5,"runs":595,"wickets":22,"bestinning":"4\/51","bestmatch":"4\/51","econ":"5.51","average":"27.04","strike":"29.4","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":13,"balls":833,"overs":138.5,"runs":552,"wickets":11,"bestinning":"3\/66","bestmatch":"3\/119","econ":"3.97","average":"50.18","strike":"75.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"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":"ada17d1073d51b67bdacc2ec9ee7dd5a","modified":"2025-06-19 08:45:54","datetime":"2025-06-19 08:45:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90789 AND DataTypeId = 6 END
Player profile of Prayash Singh, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

Sri LankaSri Lanka*203/1 (50 ov)

Bangladesh495/10 (153.4 ov)

 Day 3 - Session 2, Sri Lanka trail by 292 runs.
LIVETodayMatch 1

Bhopal Wolves WomenBhopal Wolves Women*25/1 (4.3 ov)

Bundelkhand Bulls Women109/8 (20 ov)

 Rain Delay : Bhopal Wolves Women need 85 runs in 15.3 remaining overs
LIVETodayMatch 10

Royal North BrothersRoyal North Brothers*93/9 (16.5 ov)

Irises Cricket Club

 Irises Cricket Club elected to bowl
LIVETodayMatch 16

Servotech Siliguri StrikersServotech Siliguri Strikers0/0 ( ov)

Murshidabad Kings

 Murshidabad Kings elected to bowl
LIVETodayMatch 16

Rashmi Medinipur Wizards WomensRashmi Medinipur Wizards Womens*11/1 (3.3 ov)

Sobisco Smashers Malda Womens

 Sobisco Smashers Malda Womens elected to bowl
LIVETodayMatch 29

Puneri BappaPuneri Bappa

Satara Warriors

 Toss dealyed due to rain
LIVETodayMatch 2

Prague TigersPrague Tigers

Prague Barbarians CC0/0 ( ov)

 Prague Barbarians CC elected to bat
CancelledTodayMatch 9

Pakyong XIPakyong XI

Black Eagle SAP

 Match abandoned
CancelledTodayMatch 15

Shrachi Rarh Tigers WomensShrachi Rarh Tigers Womens

Harbour Diamonds Womens

 Match abondoned due to rain
CancelledTodayMatch 28

Kolhapur TuskersKolhapur Tuskers

Raigad Royals

 Match Abandoned due to rain
ScheduledTodayMatch 8

Ami Super AvengersAmi Super Avengers

Pruthvi Panthers

 
ScheduledTodayMatch 14

Chamble GhariyalsChamble Ghariyals

Bhopal Leopards

 
ScheduledTodayMatch 5

North-West WarriorsNorth-West Warriors

Northern Knights

 
Scheduled19 June Match 3

BohemiansBohemians

Brno CC

 
Scheduled19 June Match 4

Prague TigersPrague Tigers

United CC

 
Scheduled19 June Match 9

A4 Power StrikersA4 Power Strikers

Diamond Dazzlers

 
Scheduled19 June Match 30

The BlazeThe Blaze

Lancashire Women

 
Scheduled19 June Match 30

Ratnagiri JetsRatnagiri Jets

Eagle Nashik Titans

 
CricDirect Cricket News, Results and Stats
 

Prayash Singh

NationalityIndia
RoleBowler
Born02 Feb 1994 (31)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 17 15 3 175 75 14.58 142 123.23 - 1
List A 25 20 3 267 51 15.70 256 104.29 - 2
1st Class 8 11 - 294 104 26.72 502 58.56 1 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 17 12 21 165 5 3/6 33.00 7.85 25.2 - -
List A 25 20 107.5 595 22 4/51 27.04 5.51 29.4 1 -
1st Class 8 13 138.5 552 11 3/66 50.18 3.97 75.7 - -
× Close