small problem in using assembly class in c#.net

Question

i want to add a .mdb file to the resource, and while running i want to copy .mdb file to another location, do connection run it and delete the copied .mdb file while i finished processing with .mdb file.

how to do this using assembly.GetManifestStream? if not with assembly.GetManifestStream what are the other ways with which i can do this?

Answer 1

Why can't you just use a file level copy? Not sure why you want to do it with the stream. Just find the path to the mdb file and

File.Copy(path1,path2);

Answer 2

Yes, Assembly.GetManifestStream is the way to go combined with a BinaryReader and a BinaryWriter. To wit:

// assembly is Assembly containing the resource
// path is string containing path to write to
Stream source = assembly.GetManifestResourceStream("Namespace.filename.mdb");
BinaryReader br = new BinaryReader(source);
BinaryWriter bw = new BinaryWriter(path, FileMode.Create);
byte[] buffer = new byte[256];
int count = 0;
while((count = br.Read(buffer, 0, 256)) > 0) {
    bw.Write(buffer, 0, count);
}

Obviously all those IDisposables should be wrapped in a using block.