How to connect to offline cube file in .NET 7

Erfan Gholami 0 Reputation points
2023-03-06T08:14:13.1266667+00:00

hi

In .NET Framework 4.5 we could easily connect to Offline cube files with this code :

AdomdConnection conn = new AdomdConnection();
conn.ConnectionString = "Provider=MSOLAP;Data Source='e:\\xxx.cub';Integrated Security=SSPI";
conn.Open();

but in .NET 7 , We encounter an error :

System.NotSupportedException: 'This feature is not supported for a .NET Core client.'

Does Microsoft have plans to communicate with Offline cube files in the future? Or will this feature only be available in .net framework versions?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,352 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sedat SALMAN 13,075 Reputation points
    2023-03-22T10:25:49.3733333+00:00

    As of my knowledge cutoff date in September 2021, there have been no official announcements from Microsoft regarding support for connecting to offline cube files using ADOMD.NET in .NET Core or .NET 5+.

    One of the reasons for this is that the transition from .NET Framework to .NET Core and the newer .NET versions has involved a significant refactoring of libraries and dependencies, with an emphasis on cross-platform compatibility and performance improvements. Some older technologies and features, such as support for offline cube files, might not be prioritized for newer .NET versions due to low demand or because they are considered outdated.

    It's worth noting that the open-source community has created a project called ADOMD.NET Core, which aims to provide an ADOMD.NET client library for .NET Core. However, this project is not officially supported by Microsoft, and it may not provide full compatibility with offline cube files. You can find the ADOMD.NET Core project on GitHub here: https://github.com/NetCoreApps/AdomdClientNetCore

    In conclusion, there are no guarantees that Microsoft will add support for offline cube files in .NET 7 or future .NET versions. If your application relies heavily on this feature, you might need to continue using .NET Framework 4.5 or explore alternative solutions, such as migrating your data to a modern data storage and analysis platform.

    0 comments No comments