Store an object in database using Entity Framework

Question

I plan to save some objects into a database using Entity Framework code first, so I create the classes and generate the database from that.

The files I store are the following:

An HTML file
and a .mview file.

These two are exported using Marmoset Viewer. I plan to store them as object type. All I need to do is copy them to folders (and add a new one to the database).

My question is: is this way, going with an object type doable? Or do I have to change something?

The HTML file will be opened using a WebBrowser control. It works, but so far I haven't made the database just yet.

If both files are simply text, you can use string, if not I'd use byte[]. — mxmissile
– mxmissile, Commented Mar 23, 2017 at 17:40
The html file is indeed text, though I will need its file name as well. The other though, its type is .mview as I wrote, I don't have to manage it, just move it somehow. So in case I misunderstood something, in c# code I shall use a byte[] ? So not in the data tables — agiro
– agiro, Commented Mar 23, 2017 at 17:46
Thanks. So I can read a file from disk e.g. (that mview file) into an array of bytes? (binary formatter maybe?) I might be missing something, So the issue is that AFAIK c# doesn't understand this .mview. I can just read it into a byte array? :D — agiro
– agiro, Commented Mar 23, 2017 at 17:55

mxmissile · Accepted Answer · 2017-03-23 18:30:51Z

1

Your entities, use byte[] for storing binary files. Your matching table column types should be varbinary.

You can use System.IO.File.ReadAllBytes to load your entity's property.

answered Mar 23, 2017 at 18:30

mxmissile

11.7k6 gold badges57 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Store an object in database using Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related