Integration with cache database

Question

Question

chintan lakhavara · Mar 26, 2018

We have an application made in asp.net and want to make a integration for our client who is using cache database. So can any one suggest how to communicate with the database as we are new to this system.

Discussion (6)0

Log in or sign up to continue

Dmitry Maslennikov · Mar 26, 2018

You can find online documentation here

If you need to make integration with the local instance you can connect directly to the database, using Caché eXTreme, or just ODBC

0 0

score 0 · Answer 1 · 2018-03-26T02:31:28-04:00

There are any number of ways to connect with the DB. ODBC, REST api, jdbc, nodejs,... It really comes down to your requirements.

score 0 · Answer 2 · 2018-03-26T02:40:45-04:00

chintan lakhavara · Mar 26, 2018

Can we get any type of document for the implementation using the DB,ODBC,REST api

0 0

score 0 · Answer 3 · 2018-03-26T04:57:14-04:00

Have a look at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls
you'll find coverage on each of those.

score 0 · Answer 4 · 2018-03-27T04:24:00-04:00

Evgeny Shvarov · Mar 27, 2018

Hi, Chintan!

Have you seen this article? Maybe it's relevant.

0 0

score 0 · Answer 5 · 2018-03-29T13:48:49-04:00

Add the reference to cache provider for .net

using InterSystems.Data.CacheClient;

CacheDataReader dr;

using (CacheConnection con = new CacheConnection())
{
con.ConnectionString = "Server=" + Servername+ ";" + "Port=1972; Namespace=Namespace;" + "Password=" + Password + ";" + "User ID=" + UserName + ";";

CacheCommand cmd;
cmd = new CacheCommand("select * from table", con);
con.SetQueryRuntimeMode(InterSystems.Data.CacheTypes.QueryRuntimeMode.DISPLAY);
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read()){ // do your stuff }
}