Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Couple comments. </p> <ol> <li>Don't use the J# runtime. J# has been discontinued by Microsoft. Future support is questionable. Also, the entire J# runtime is a big nut to swallow when all you want is ZIP support.</li> <li>The GzipStream in System.IO.Compression, part of the .NET base class library since .NET 2.0, provides a stream interface for <a href="http://www.ietf.org/rfc1952.txt" rel="noreferrer">IETF RFC-1952</a> compression. It is ok for compression, though the compression ratio is not optimal and it will significantly expand data that has been previously compressed. This <a href="https://connect.microsoft.com/VisualStudio/feedback/details/93636/gzipstream-deflatestream-increase-file-size-on-compression" rel="noreferrer">bug was reported to Microsoft, but it's apparently been closed</a>. There is also a DeflateStream which is similar, but for <a href="http://www.ietf.org/rfc1951.txt" rel="noreferrer">RFC 1951</a>. There's a common misconception that GZipStream does zip files. Not true. <strong>Neither of these two do zip files.</strong> </li> <li>There's System.IO.Packaging.ZipPackage. It works, but is designed and intended primarily for packaging of MS Office 2007 (.docx, .xslx, and .pptx) files. It's unwieldy for zip files and doesn't support lots of ZIP features, like encryption.</li> <li>If you want a flexible way to create and read zip files in .NET you need a 3rd party library, currently. </li> </ol> <p><a href="http://DotNetZip.codeplex.com/" rel="noreferrer"><strong>DotNetZip</strong></a> is a good 3rd party option. Free, open source, actively maintained, simple to use, small, good feature set. It is shipped as a single assembly - it is fully managed code. Works on Compact Framework as well as on the regular .NET Framework. The pre-req is .NET 2.0. </p> <p>DotNetZip also includes a ZLIB library, with classes like {Zlib,GZip,Deflate}Stream. They are comparable to those built-in to .NET, but they include the ability to set Compression Levels, and at higher levels they compress much more effectively than the built-in classes. The ZlibStream does <a href="http://www.ietf.org/rfc1950.txt" rel="noreferrer">RFC 1950</a> compression. </p> <p>DotNetZip does ZIP64, passwords, AES encryption, streams, SFX, and Unicode. Everyone who uses it says it is much simpler to use than SharpZipLib. There's a good help file (.chm) and lots of code examples.</p> <p><a href="http://i27.tinypic.com/2nl8fwk.jpg" rel="noreferrer">DNZ CHM http://i27.tinypic.com/2nl8fwk.jpg</a></p>
    singulars
    1. This table or related slice is empty.
    1. POOpen-source zip library for .NET?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCheeso
    1. USCheeso
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODo you know, can DotNetZip be included in an open source project? I heard that Microsoft Public License cannot be used together with a GPL.
      singulars
      1. PO
      1. USZenya
    2. COFirst, I'm not an IP attorney or an expert on software licenses and their mutual compatibility. However, I am confident that I can answer your first question affirmatively: DotNetZip can be used in an open source project. There is a second, implied question in your comment: Can a library licensed under the MS-PL be used together with code or a library licensed under the GPL? That is a different question entirely, and I won't attempt to answer it. I'm not sure, but there may be an assumption on your part that "open source implies GPL". This is not a valid assumption.
      singulars
      1. PO
      1. USCheeso
    3. COGreat library, thanks!
      singulars
      1. PO
      1. USnrodic
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload