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:3420ab49-d701-441d-983b-f5f248b2b193 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 94364 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (94364,6,'{"status":"ok","response":{"player":{"pid":94364,"title":"Soyeb Sopariya","short_name":"S Sopariya","first_name":"Soyeb Sopariya","last_name":"","middle_name":"","birthdate":"1994-09-10","birthplace":"Mesrad District. Baroda, Gujarat","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/soyeb_sopariya_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":10,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":1,"notout":1,"runs":11,"balls":19,"highest":11,"run100":0,"run50":0,"run4":1,"run6":0,"average":"","strike":"57.89","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":14,"notout":3,"runs":48,"balls":198,"highest":12,"run100":0,"run50":0,"run4":8,"run6":0,"average":"4.36","strike":"24.24","catches":1,"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":10,"innings":10,"balls":216,"overs":36,"runs":225,"wickets":8,"bestinning":"3\/16","bestmatch":"3\/16","econ":"6.25","average":"28.12","strike":"27.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"balls":174,"overs":29,"runs":100,"wickets":4,"bestinning":"3\/8","bestmatch":"3\/8","econ":"3.44","average":"25.00","strike":"43.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":14,"balls":1145,"overs":190.5,"runs":582,"wickets":21,"bestinning":"5\/83","bestmatch":"5\/81","econ":"3.04","average":"27.71","strike":"54.5","wicket4i":0,"wicket5i":1,"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":"25330d3fa46d3d90165141112be0ccef","modified":"2025-07-08 16:10:11","datetime":"2025-07-08 16:10:11","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":94364,"title":"Soyeb Sopariya","short_name":"S Sopariya","first_name":"Soyeb Sopariya","last_name":"","middle_name":"","birthdate":"1994-09-10","birthplace":"Mesrad District. Baroda, Gujarat","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":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/soyeb_sopariya_\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":10,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":1,"notout":1,"runs":11,"balls":19,"highest":11,"run100":0,"run50":0,"run4":1,"run6":0,"average":"","strike":"57.89","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":14,"notout":3,"runs":48,"balls":198,"highest":12,"run100":0,"run50":0,"run4":8,"run6":0,"average":"4.36","strike":"24.24","catches":1,"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":10,"innings":10,"balls":216,"overs":36,"runs":225,"wickets":8,"bestinning":"3\/16","bestmatch":"3\/16","econ":"6.25","average":"28.12","strike":"27.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"balls":174,"overs":29,"runs":100,"wickets":4,"bestinning":"3\/8","bestmatch":"3\/8","econ":"3.44","average":"25.00","strike":"43.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":8,"innings":14,"balls":1145,"overs":190.5,"runs":582,"wickets":21,"bestinning":"5\/83","bestmatch":"5\/81","econ":"3.04","average":"27.71","strike":"54.5","wicket4i":0,"wicket5i":1,"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":"25330d3fa46d3d90165141112be0ccef","modified":"2025-07-08 16:10:11","datetime":"2025-07-08 16:10:11","api_version":"3.0"}', Modified = GetDate() WHERE Id = 94364 AND DataTypeId = 6 END
Player profile of Soyeb Sopariya, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday3rd ODI

Sri LankaSri Lanka285/7 (50 ov)

Bangladesh*171/8 (36.4 ov)

 Bangladesh need 115 runs in 13.2 remaining overs
LIVETodayMatch 5

Yanam RoyalsYanam Royals164/9 (20 ov)

Mahe Megalo Strikers*133/5 (17.4 ov)

 Mahe Megalo Strikers need 32 runs in 14 remaining balls
LIVETodayMatch 41

Somerset WomenSomerset Women*121/3 (15 ov)

Essex Women155/5 (20 ov)

 Somerset Women need 35 runs in 30 remaining balls
LIVETodayMatch 6

NetherlandsNetherlands*31/2 (5.1 ov)

Scotland148/9 (20 ov)

 Netherlands need 118 runs in 14.5 remaining overs
LIVETodayMatch 6

Turkey WomenTurkey Women221/4 (20 ov)

Bulgaria Women*0/0 ( ov)

 Innings Break : Bulgaria Women need 222 runs in 20 remaining overs
LIVETodayMatch 20

Northern KnightsNorthern Knights*146/6 (17.4 ov)

North-West Warriors

 North-West Warriors elected to bowl
LIVETodayMatch 10

Leuven LionsLeuven Lions84/10 (9.4 ov)

Brussels Bashers*7/0 (0.5 ov)

 Brussels Bashers need 78 runs in 55 remaining balls
LIVETodayMatch 29

Whiptail SmashersWhiptail Smashers*0/0 (0.0 ov)

Piton Stickers

 Match Start Delay : Whiptail Smashers elected to bat
ScheduledTodayMatch 4

ACE KRM PanthersACE KRM Panthers

Super Lanka

 
Scheduled08 July Match 89

SomersetSomerset

Essex

 
Scheduled08 July Final

Amazonian WarriorsAmazonian Warriors

Iyanola Heritage

 
Scheduled09 July Qualifier (1v2)

Washington FreedomWashington Freedom

Texas Super Kings

 
Scheduled09 July 3rd unofficial ODI

Australia AAustralia A

Sri Lanka A

 
Scheduled09 July Match 5

PhilippinesPhilippines

South Korea

 
Scheduled09 July Match 3

91 Yard Club91 Yard Club

Bud CC

 
Scheduled09 July Match 6

South KoreaSouth Korea

Indonesia

 
Scheduled09 July Match 11

Antwerp GiantsAntwerp Giants

Gent Wolves

 
CricDirect Cricket News, Results and Stats
 

Soyeb Sopariya

NationalityIndia
RoleBowler
Born10 Sep 1994 (30)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 10 - - - - - - - - -
List A 5 1 1 11 11 - 19 57.89 - -
1st Class 8 14 3 48 12 4.36 198 24.24 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 10 10 36 225 8 3/16 28.12 6.25 27.0 - -
List A 5 4 29 100 4 3/8 25.00 3.44 43.5 - -
1st Class 8 14 190.5 582 21 5/83 27.71 3.04 54.5 - 1
× Close