Search code examples
c#.netintersystems-cache

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

Solution

  • 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!