For the simplicity we will use MSSQLProvider to fetch the data from the database. This class has basic functionality, if you want to create complex database queries, for example JOIN, you'd better use something like Entity Framework. - Source: dev.to / 12 months ago

I only wanted to give a simple preview of what can be done with Entity Framework, but if this is something that interests you and you want to go further in-depth with all the possibilities, I recommend checking out the official docs where you can also find a great tutorial which will guide you through building your very own .NET Core web application. - Source: dev.to / almost 2 years ago

Entity Framework documentation hub - Entity Framework is a modern object-relation mapper that lets you build a clean, portable, and high-level data access layer with .NET (C#) across a variety of databases, including SQL Database (on-premises and Azure), SQLite, MySQL, PostgreSQL, and Azure Cosmos DB. It supports LINQ queries, change tracking, updates, and schema migrations. Source: almost 2 years ago

You can create the DAL using your existing code or start using a Object Relational Mapper like Entity Framework which will do a lot of the work for you, check this out here: https://learn.microsoft.com/en-us/ef/ also check out LINQ. Source: about 2 years ago

And, possibly (not strictly speaking necessary but very useful) Entity framework as a backend part of it. Source: about 2 years ago

In conclusion, Apache POI stands as an inspiring hallmark of what open source can achieve when community collaboration meets smart governance and sustainable funding. From its rich feature set and comprehensive documentation on the official website to its dynamic development on GitHub, Apache POI remains a beacon for modern software development practices. By embracing both traditional funding and exploring... - Source: dev.to / 2 months ago

Recently I needed to write an Azure Function app that uses the Apache POI library for getting the text from Microsoft Word 94 documents (and yes, I am fully aware that the year is currently 2024, but some people still have 30 year old documents kicking around!). - Source: dev.to / about 1 year ago

I need to add the apache poi to my project (I need hssf, ss and xssf). I downloaded a jar file from the internet but it does not contain xssf. I went to http://poi.apache.org/ and I downloaded this: http://www.apache.org/dyn/closer.cgi/poi/release/src/poi-src-3.9-20121203.zip, I extract it..and got stucked. I tried Part 1 but that was only for JavaDoc. Source: about 2 years ago

- Using Ports to call CLIs that take care of this (e.g. Poppler for PDFs, Libreoffice in `--headless` mode) - Use jInterface to startup a JVM with Apache POI to work on this specific workflow (I have an example here to work with Java Image API). You can also do this with other languages (Golang , Python and other). Source: over 2 years ago

If you can use third party libraries, you can look at Apache POI (https://poi.apache.org/). It allows you to read, write and manipulate Excel and CSV files. Source: over 2 years ago