How can i get nuget to use oledb in asp5 mvc6

Question

0.00/5 (No votes)

See more:

hi,
i'm working with asp5 mvc6. But we could not take reference of System.Data in DNX core 5.0 .
can you plz hepl me

What I have tried:

i have instale Glimpse.Ado and it doesn't work and i have uninstall it

Posted 11-Feb-16 1:24am

Member 11573837

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2016-02-11T03:43:00

Solution 1

The System.Data namespace is not currently supported in .NET Core, although it is on the "considered for porting" list.

Porting to .NET Core | .NET Blog[^]:

System.Data While the base layer is already part of .NET Core, i.e. the provider model and SQL client, some features are currently not available, such as schema support and DataTable/DataSet.

It might be worth logging this as an issue on the GitHub project:
Issues · dotnet/corefx · GitHub[^]

Posted 11-Feb-16 3:43am

Richard Deeming

Comments

Member 11573837 11-Feb-16 10:19am

hi Richard Deeming,
thank you for anwering me.Do you have any idea how can i read data from excel file with asp.net5 mvc 6, because i have make it in asp.net it work nice but in asp5 didn't want because using system.data

Richard Deeming 11-Feb-16 10:28am

You can read Excel 2007 files (.xlsx) using the OpenXML SDK[^].

However, it looks like that doesn't support .NET Core yet:
https://github.com/OfficeDev/Open-XML-SDK/issues/65[^]

ExcelDataReader doesn't support it yet either:
https://github.com/ExcelDataReader/ExcelDataReader/issues/72[^]

I can't find any information about .NET Core support for either EPPlus[^] or ClosedXML[^].

Even NPOI[^] makes no mention of it.

I guess once .NET Core is finally released, some of these libraries might start adding support. Until then, unless you can get one of the libraries to recompile under .NET Core, I don't have any suggestions.

Member 11573837 12-Feb-16 9:39am

Hi Richard Deeming,
thank you for answering me i have use the OpenXml SDK and i have another issue is the DNX Core 5.0 do not support DocumentFormat.OpenXml whene i add nuget

Richard Deeming 12-Feb-16 9:42am

Which is what I said in my previous comment - it doesn't support .NET Core yet.

Unless you can get one of the libraries to recompile under .NET Core, your only option is to switch back to the regular .NET Framework, or wait until .NET Core is released and one of the libraries is updated to support it.