Trouble connecting to SQL Server Express with a C# AWS Lambda function

Question

I get the following error when trying to connect to my SQL Server Express RDS instance over AWS Lambda using System.Data.SqlClient:

"errorType": "PlatformNotSupportedException",
"errorMessage": "Operation is not supported on this platform.",
"stackTrace": [
"at System.Runtime.InteropServices.OSPlatform.get_Windows()",
"at System.Data.SqlClient.SNI.SNITCPHandle.d__22.MoveNext()"
]

I build the deploy package using Amazon.Lambda.Tools. Running the function and connecting to the database from local works fine, but fails when trying to run it on AWS Lambda.

Here is my project.json:

{
"version": "1.0.0-*",
"description": "AWS lambda Console Application",
"authors": [ "" ],
"packOptions": {
    "tags": [],
    "projectUrl": "",
    "licenseUrl": ""
},
"buildOptions": {
    "emitEntryPoint": true
},
"dependencies": {
    "Microsoft.NETCore.App": {
    "type": "platform",
    "version": "1.0.0"
    },
    "Newtonsoft.Json": "9.0.1",
    "Amazon.Lambda.Core": "1.0.0*",
    "Amazon.Lambda.Serialization.Json": "1.0.1",
    "Amazon.Lambda.Tools": {
    "type": "build",
    "version": "1.0.0-preview1"
    },
    "Dapper": "1.50.2",
    "System.Data.SqlClient": "4.3.0"
},
"tools": {
    "Amazon.Lambda.Tools": "1.0.0-preview1"
}, 
"commands": {
    "AwsLambda": "run"
},
"frameworks": {
    "netcoreapp1.0": {
        "imports": "dnxcore50"
    }
}
}

Hi @torryt, pls how did you fix this?

Akin
– Akin

2017-02-20 22:27:00 +00:00
Commented Feb 20, 2017 at 22:27 — Akin
– Akin, Commented Feb 20, 2017 at 22:27

John Ten Cate · Accepted Answer · 2017-02-15 15:40:40Z

5

Had the same problem and for me just changing

"System.Data.SqlClient": "4.3.0"

to

"System.Data.SqlClient": "4.1.0"

worked for me. I did not have to change the NetCore.App dependencies.

answered Feb 15, 2017 at 15:40

John Ten Cate

4955 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris Voon · Accepted Answer · 2017-04-08 18:27:05Z

2

Explicitly add reference to

"System.Data.SqlClient": "4.1.0",
"System.Runtime.InteropServices.RuntimeInformation": "4.0.0"

solves the problem.

answered Apr 8, 2017 at 18:27

Chris Voon

2,0092 gold badges19 silver badges11 bronze badges

1 Comment

micdah Over a year ago

We had been pulling our hair out, over this issue. Finally for the heck of it, we tried your suggestion, and lo and behold, it actually worked! Super annoying issue, but thank god we found a solution.

ρяσѕρєя K · Accepted Answer · 2017-02-13 04:41:08Z

1

Can you try to change

"System.Data.SqlClient": "4.3.0"

to

"System.Data.SqlClient": "4.1.0"

and change

"dependencies": {
    "Microsoft.NETCore.App": {
    "type": "platform",
    "version": "1.0.0"
    },

to

"dependencies": {
    "Microsoft.NETCore.App": {
    "type": "platform",
    "version": "1.0.1"
    },

edited Feb 13, 2017 at 4:41

ρяσѕρєя K

133k54 gold badges203 silver badges216 bronze badges

answered Feb 13, 2017 at 2:53

solaris wu

112 bronze badges

Collectives™ on Stack Overflow

Trouble connecting to SQL Server Express with a C# AWS Lambda function

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related