Extract Data From SQL2008 with Entities

Question

0.00/5 (No votes)

See more:

I need to generate a script that will insert data into SQL 2008 database. Everything is working fine except that I am storing files in the database in a varbinary field. I extract the data but when I try run the scripts it just freaks out. This is how I am doing it.

C#

using (StreamWriter sw = new StreamWriter(Console.ReadLine() + ".sql"))
            {
                foreach (File b in context.Files)
                {
                    sw.WriteLine("INSERT INTO [File] VALUES ({0}, {1}, {2}, {3})", b.FileID, b.FileName, b.MIME, ASCIIEncoding.UTF8.GetString(b.BinaryData));
                }
                sw.Flush();
                sw.Close();
            }

Any help would be great!

Edit:
I don't need to execute the script, I just need to write it to a file. The exception is not thrown in the app, I just need to know how to write the content from the varbinary in such a way that I can execute the scripts to add ot to another db at a later stage.

Posted 29-Oct-11 6:51am

DominicZA

Updated 29-Oct-11 8:49am

Sander Rossel

v2

Add a Solution

Comments

Sander Rossel 29-Oct-11 14:49pm

Please don't answer your question with another question. I have updated your question for all to see.

Sander Rossel 29-Oct-11 15:00pm

See my edited answer. Hope it helps! :)

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)

Sander Rossel · Answer 1 · 2011-10-29T06:59:00

Am I missing something? That StreamWriter does nothing. You write to it, then Flush, Close and Dispose. Also, where does the context.Files come from? Your question mentions Entities which leads me to think context is an ObjectContext and File is a Table in your Database.
So what does this code do? It iterates through the File table records, writes a SQL statement that inserts the already existing records into the same table to a Stream, then Disposes of the Stream the end.

So what is context exactly and what are you trying to achieve? If I read this I cannot conclude, but that this code does nothing except, throw Exceptions. Could you mention the Exception too?

Edit; OP has edited his question.
The following code will create a new .txt file on the C:\ drive. It's initial text will be "Test", but every time the code passes this again "Test" will be appended on a new line.

C#

string s = "Test" + Environment.NewLine;
using (System.IO.FileStream fs = new System.IO.FileStream(@"C:\MyFile.txt", System.IO.FileMode.Append)) {
    using (System.IO.StreamWriter writer = new System.IO.StreamWriter(fs)) {
        writer.Write(s);
        writer.Flush();
        fs.Flush();
        writer.Close();
        fs.Close();
    }
}

I suggest you build the String in your loop and then use this code to append it to your file.
Hope this is what you are looking for/what you need.