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.

asked 19 Oct, 11:04

dharrel's gravatar image

dharrel
1312212
accept rate: 0%


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, 07:33

beater's gravatar image

beater
262
accept rate: 0%

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

(20 Oct, 08:43) dharrel
Your answer
toggle preview

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

Question tags:

×65

question asked: 19 Oct, 11:04

question was seen: 178 times

last updated: 20 Oct, 08:43