How do I insert any file extension into an SQL database?

Question

I always worked attaching only images in my BDD tables, I remember that converted to MemoryStream and then to Byte and inserted... But I need to insert any kind of file extension in my database.

Answer 1

Safe way to do what you want:

public static int databaseFilePut(MemoryStream fileToPut) {
    int varID = 0;
    byte[] file = fileToPut.ToArray();
    const string preparedCommand = @"
                INSERT INTO [dbo].[Raporty]
                           ([RaportPlik])
                     VALUES
                           (@File)
                    SELECT [RaportID] FROM [dbo].[Raporty]
        WHERE [RaportID] = SCOPE_IDENTITY()
                ";
    using (var varConnection = Locale.sqlConnectOneTime(Locale.sqlDataConnectionDetails))
    using (var sqlWrite = new SqlCommand(preparedCommand, varConnection)) {
        sqlWrite.Parameters.Add("@File", SqlDbType.VarBinary, file.Length).Value = file;

        using (var sqlWriteQuery = sqlWrite.ExecuteReader())
            while (sqlWriteQuery != null && sqlWriteQuery.Read()) {
                varID = sqlWriteQuery["RaportID"] is int ? (int) sqlWriteQuery["RaportID"] : 0;
            }
    }
    return varID;
}

I put in the Github for future reference.

Withdrawn of that response in the OS.

You can simplify some things if you don’t need all the features but you haven’t shown your specific need.

You just won’t take the using and leave the code vulnerable to resource leakage.

Note the use of type VarBinary for the SQL Server column.