Integration with cache database

Caché, .NET

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.

Answers

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

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 }
}

Comments

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

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