Access SQL Anywhere from .NET Core 3.1

What is the preferred way to access SQL Anywhere from a .NET Core 3.1 application?

Last December (2019) the question https://sqlanywhere-forum.sap.com/questions/34551/planned-net-core-support-again produced a statement from SAP, "there are no plans to add .NET Core support to SQL Anywhere clients at this time."

We would like to write a REST .NET web service in C# .NET Core 3.1, accessing a SQL Anywhere 16 or 17 database.

Thanks.

.net

asked 19 Oct '20, 11:04

dharrel
280●12●12●23
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

We use ODBC. First get a SQL Anywhere ODBC connection working. Then in your Core project install the nuget package System.Data.Odbc. You can then use OdbcConnection etc to access your data.

permanent link

answered 20 Oct '20, 07:33

beater
89●2●2●9
accept rate: 0%

Thanks. And it looks like connection pooling is supported, which is important.

(20 Oct '20, 08:43) dharrel

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

.net ×76

question asked: 19 Oct '20, 11:04

question was seen: 1,788 times

last updated: 20 Oct '20, 08:43

SAP SQL Anywhere

Access SQL Anywhere from .NET Core 3.1

Follow this question

Related questions