.NET | InterSystems Developer Community

Question

Vivek Ranjan · Nov 22, 2017

DATEPART(hour, columnName) function takes logical mode (in memory stored data) as input to column while executing the script in 'Display' and 'ODBC' mode

I ran the below query in three different modes. Coordinated Universal Time is 5 hours ahead of Eastern Time so there is difference in value from column 1 and column 2 in ODBC, Display mode, but not in Logical Mode. By default the query executes in ODBC mode when we query the data from outside world(via ODBC connection).

I don't know why query 2 and query 3 outputs different from query 1.

Query 1. Ran in Logical mode, DATEPART() took in memory stored timestamp data(stored in UTC)

#.NET #ODBC #Caché

0 3

0 396

Question

Razvan Prepelita · Aug 30, 2017

Performance issue with importing Dashboards url

I have a main page in .NET where I call a Dashboard created in DeepSee like this:

to display the Dashboard in the .NEt page.

My problem is that connection to every Dashboard takes a while, so performance is low.

Any suggestion?

#InterSystems IRIS BI (DeepSee) #Dashboards #.NET

0 3

0 354

Question

Razvan Prepelita · Sep 8, 2017

Timer method (execute the method at a defined interval)

My scenario is:

I have a Cache method that

call a REST -> JSON -response > INSERT/UPDATE the source table of a DeepSee Cube -> Update the Cube only for this change -

I want to view in .NET Application the changes. For that I want that this method should be executed at a defined interval.

Or maybe the solution is a Refresh button in .NET page. is there any way to access a Cache method from .NET?

Any idea how to do it?

#InterSystems IRIS BI (DeepSee) #.NET #Caché

0 1

0 374

Question

Laura Blázquez ... · Aug 16, 2017

DotNetGateway port already in use

We have some productions in Ensemble that uses DotNetGateway to use dll created with .Net. The DotNetGateway is configured with a port number, and then the operation uses that port.

#Ensemble #.NET #Microsoft Windows Server

0 1

0 327

Question

Uri Shmueli · Jul 13, 2017

.Net Gateway Parallel Calls – Optimal Number?

More calls in parallel to a single .Net Gateway can yield better performance, but too many could cause problems. What is the "Right" number? What do you do/recommend?

#.NET #Caché

1 2

0 305

Question

Chris Sprague · Jul 4, 2017

Implementing a Native Client for C#

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.

#Caché #.NET

0 9

0 772

Question

Richard Roeder · Jun 20, 2017

How can I fix it: " 'VARBINARY' is not a supported type for CAST" ?

Hi all,

I trying build a project with .NET and Entity Framework in the Code First method, but Caché return the error " 'VARBINARY' is not a supported type for CAST" when run this sql code:

#API #.NET #Caché

0 3

0 640

Question

Seth Jaffe · Feb 13, 2017

Connecting using factory

The following code in .Net using CacheObject.dll version 2016.1.2.206 com library

ConnectionString = "cn_iptcp:10.56.135.160[1972]:PHDEMO:PHSYSADM:***********"

b = factory.Connect(ConnectionString )
objCacheObject = factory.Static("CacheObjectConnection")
clist = factory.GetConnectionList()

for the above code, b is true and clist is Local,cn_iptcp:127.0.0.1[1972]:

#.NET #Object Data Model #Caché

0 1

0 430