Implementing a Native Client for C#

Question

Question

Chris Sprague · Jul 4, 2017

Hello,

I'm currently exploring alternatives to CSP/services and ODBC/Sql Maps for access to Caché. I'm not seeing a library which would interest me, so am considering creating one myself.

Does 'CacheConnection' in C# use RPC of some sort, or a defined protocol to communicate with Caché, or does it do so over telnet with scripted commands? I would assume the former. If so, is this a publicly documented protocol that can be implemented by library developers?

Any guidance in this area would be appreciated.

Discussion (9)0

Log in or sign up to continue

Chris Sprague · Jul 6, 2017

From existing libraries, I think the answer is to script the human-readable telnet connection...

https://github.com/agsh/boobst/blob/master/boobst.js

This guy's written an interesting one in ECMAScript.

0 0

score 0 · Answer 1 · 2017-07-04T05:00:50-04:00

Are you sure that you not overlooked something in the Documentation?

How about .Net Caché eXTreme

If you still sure that it is not enough. You can create own, based on any already realized ways, for example on C++ binding

score 0 · Answer 2 · 2017-07-06T03:43:09-04:00

Hi Dmitry,

Thank you for your response. .Net Caché eXTreme was interesting... I've read through that page before. The main downside would be having to either implement software on the same server as Caché installation, or having to implement (and maintain, deploy, etc.) middleware and designing my own protocol for remote use.

I'll have a look at the C++ binding. Do you happen to know if this uses telnet as if it was entered by a human user, or some other protocol? I'm not concerned with performance at this point, really, but I am hesitant to interact with the existing telnet in a way that simulates human input as that's not particularly what it was designed for.

Thanks again for your answer, I'll have a look at the C++ code.

score 0 · Answer 3 · 2017-07-06T03:55:17-04:00

I'm having a look at some of the implementations you've linked to. The node.js one looks close to what I would want to do in C#...

score 1 · Answer 4 · 2017-07-06T03:53:25-04:00

Hi Evgeny,

I use the EF.NET provider already. This is equivalent to using ODBC (I believe the provider is based upon, and uses, ODBC to connect to Caché.)

I think this is the ideal tool for developers to use for Caché at the moment, but I'm interested in exploring a means of querying which won't require SQL and can be written in a style more idiomatic to Caché.

score 0 · Answer 5 · 2017-07-06T04:03:16-04:00

The main downside would be having to either implement software on the same server as Caché installation

Establishing a TCP/IP Connection

score 0 · Answer 6 · 2017-07-06T04:39:21-04:00

Intersting... I'll have to look into this. Why does the very introduction to XP mention that Caché has to be installed on the client machine in order to use this?

score 0 · Answer 7 · 2017-07-06T04:47:15-04:00

You can write custom queries and create custom result sets that iterate over globals, etc. and expose them via ODBC.

score 0 · Answer 8 · 2017-07-05T04:19:55-04:00

Evgeny Shvarov · Jul 5, 2017

Hi, Chris!

Have you looked into .NET Managed Provider and Entity Framework? Hope that helps.

0 0