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:14cdc457-21cd-4279-86d5-317ce6534875 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49029 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49029,6,'{"status":"ok","response":{"player":{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":326,"innings":299,"notout":64,"runs":7125,"balls":5145,"highest":118,"run100":3,"run50":43,"run4":625,"run6":270,"average":"30.31","strike":"138.48","catches":142,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":63,"innings":57,"notout":11,"runs":1735,"balls":1789,"highest":134,"run100":3,"run50":5,"run4":142,"run6":52,"average":"37.71","strike":"96.98","catches":25,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":73,"innings":125,"notout":6,"runs":3495,"balls":7526,"highest":213,"run100":6,"run50":18,"run4":477,"run6":7,"average":"29.36","strike":"46.43","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"21","innings":"17","notout":"2","runs":"167","balls":"111","highest":"27","run100":"0","run50":"0","run4":"15","run6":"10","average":"11.13","strike":"150.45","catches":"5","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":326,"innings":4,"balls":22,"overs":3.4,"runs":35,"wickets":1,"bestinning":"1\/5","bestmatch":"1\/5","econ":"9.54","average":"35.00","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":63,"innings":4,"balls":54,"overs":9,"runs":82,"wickets":1,"bestinning":"1\/29","bestmatch":"1\/29","econ":"9.11","average":"82.00","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":73,"innings":11,"balls":366,"overs":61,"runs":270,"wickets":2,"bestinning":"1\/29","bestmatch":"1\/29","econ":"4.42","average":"135.00","strike":"183.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"21","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"8de236da43632924940cb0c1c9d48a3c","modified":"2025-06-20 15:05:02","datetime":"2025-06-20 15:05:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49029,"title":"Laurie Evans","short_name":"LJ Evans","first_name":"Laurie Evans","last_name":"","middle_name":"","birthdate":"1987-10-12","birthplace":"Lambeth, London","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/laurie.evans.39\/","twitter_profile":"https:\/\/twitter.com\/LaurieEvans32","instagram_profile":"https:\/\/www.instagram.com\/laurieevans32\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":326,"innings":299,"notout":64,"runs":7125,"balls":5145,"highest":118,"run100":3,"run50":43,"run4":625,"run6":270,"average":"30.31","strike":"138.48","catches":142,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":63,"innings":57,"notout":11,"runs":1735,"balls":1789,"highest":134,"run100":3,"run50":5,"run4":142,"run6":52,"average":"37.71","strike":"96.98","catches":25,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":73,"innings":125,"notout":6,"runs":3495,"balls":7526,"highest":213,"run100":6,"run50":18,"run4":477,"run6":7,"average":"29.36","strike":"46.43","catches":58,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"21","innings":"17","notout":"2","runs":"167","balls":"111","highest":"27","run100":"0","run50":"0","run4":"15","run6":"10","average":"11.13","strike":"150.45","catches":"5","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":326,"innings":4,"balls":22,"overs":3.4,"runs":35,"wickets":1,"bestinning":"1\/5","bestmatch":"1\/5","econ":"9.54","average":"35.00","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":63,"innings":4,"balls":54,"overs":9,"runs":82,"wickets":1,"bestinning":"1\/29","bestmatch":"1\/29","econ":"9.11","average":"82.00","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":73,"innings":11,"balls":366,"overs":61,"runs":270,"wickets":2,"bestinning":"1\/29","bestmatch":"1\/29","econ":"4.42","average":"135.00","strike":"183.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"21","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"8de236da43632924940cb0c1c9d48a3c","modified":"2025-06-20 15:05:02","datetime":"2025-06-20 15:05:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49029 AND DataTypeId = 6 END
Player profile of Laurie Evans, England
<>
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 Lanka485/10 (131.2 ov)

Bangladesh495/10 (153.4 ov) & *177/3 (57 ov)

 Stumps : Day 4 - Bangladesh lead by 187 runs.
LIVEToday1st Test

EnglandEngland

India*219/2 (51.3 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayMatch 11

Diamond DazzlersDiamond Dazzlers*10/1 (2 ov)

Alembic Warriors

 Rain Delay : Alembic Warriors elected to bowl
LIVETodayMatch 31

Durham WomenDurham Women101/8 (20 ov)

Essex Women0/0 ( ov)

 Innings Break : Essex Women need 102 runs in 20 remaining overs
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*38/1 (5 ov)

 Rain Delay : Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers*147/5 (17.2 ov)

Shrachi Rarh Tigers

 Lux Shyam Kolkata Tigers elected to bat
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women*127/4 (15.2 ov)

The Blaze

 Warwickshire Women elected to bat
LIVEToday6th T20I

ScotlandScotland*136/3 (13.1 ov)

Nepal

 Scotland elected to bat
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*29/1 (3 ov)

 Rain Delay : Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar*107/4 (13 ov)

JMD Kutch Riders

 JMD Kutch Riders elected to bowl
LIVETodayMatch 10

BohemiansBohemians*2/0 (0.1 ov)

Prague Tigers

 Prague Tigers elected to bowl
LIVETodayFinal

Tally RangersTally Rangers

ACE KRM Panthers

 
ScheduledTodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players

SAMP Army Cocrico Cavaliers

 
Scheduled20 June Match 65

NorthamptonshireNorthamptonshire

Nottinghamshire

 
Scheduled20 June Match 67

GlamorganGlamorgan

Somerset

 
Scheduled20 June Match 69

DurhamDurham

Yorkshire

 
Scheduled20 June Match 64

SurreySurrey

Middlesex

 
Scheduled20 June Match 66

GloucestershireGloucestershire

Hampshire

 
CricDirect Cricket News, Results and Stats
 

Laurie Evans

NationalityEngland
RoleBatter
Born12 Oct 1987 (37)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 326 299 64 7125 118 30.31 5145 138.48 3 43
List A 63 57 11 1735 134 37.71 1789 96.98 3 5
1st Class 73 125 6 3495 213 29.36 7526 46.43 6 18

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 326 4 3.4 35 1 1/5 35.00 9.54 22.0 - -
List A 63 4 9 82 1 1/29 82.00 9.11 54.0 - -
1st Class 73 11 61 270 2 1/29 135.00 4.42 183.0 - -
× Close