CODEWITHSUNDEEP
c#.netintersystems-cache
CAR1980
CAR1980

Reputation: 33

C#/EF for Intersystems Cache

My background is more in C#/.Net, and have now been offered to move to Intersystems Cache. I haven't found any recent posts on this so unless I missed something here goes: From what I understand Cache has some mapping for ADO.NET/.NET, but is there something out there so I can use Cache for the DAL and C# for the BL/front end (like ASP.NET MVC)? Is there a port somewhat similar to Xamarin, that allows one to write everything in C#, using Visual Studio? I haven't started with Cache yet, but from a brief glimpse it looks somewhat similar to C# being string based and slightly similar approach to interfaces and implementation. Thanks

Upvotes: 3

Views: 1181

Answers (2)

Ian
Ian

Reputation: 748

Yea, this is a late response, but here's something that may help, if you're still interested.

I remember back in 2009, Intersystems came out with a .Net Gateway where the Cache developer would create a DLL for you to use to call the different routines and globals. I think that has since been kaput. So I gave up and went with a linked server (static table created by a routine's nightly build) in MS SQL.

Recent searching led me to a link to a framework which I am currently looking into. I haven't tested it yet, but it is a "LinQ API to work with Caché Globals from .NET Entity Framwork"

You may also want to take a look at Caché eXTreme and the samples provided. I'm hoping to implement one of the two (or both) in order to complete a project I'm working on.

Upvotes: 0

SilentStorm
SilentStorm

Reputation: 170

Simply put: no.

However, you can use the provided DLL (InterSystems.Data.CacheClient.dll) and the reference (InterSystems.Data.CacheClient) to establish an ado connection to cache. From there you can use SQL to get your data or call a stored procedure from cache. (I'm still researching myself.)

Here's a little tutorial for a c# front-end. (a bit old though, like cache) http://www.windowsdevcenter.com/pub/a/windows/2006/03/28/oop-c-meets-cache.html?page=1

And some documentation: (this really helped me out) http://docs.intersystems.com/documentation/cache/20131/pdfs/GBMP.pdf

Good luck and happy coding!

Upvotes: 1

Related Questions