Integration with cache database
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.
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
Have a look at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls you'll find coverage on each of those.
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
Hi, Chintan!
Have you seen this article? Maybe it's relevant.
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 }
}