Entity framework Code-First - backup and restore DbContext

Question

I trying to backup data on Model change and recreate it after database creation. It's work fine but I need to write this for each class. How can I get all DbSet in DbContext and loop with this functions on it?

backup:

XmlSerializer classSerializer = new XmlSerializer(typeof(List<TextComponent>));
StreamWriter classComponentWriter = new StreamWriter(Server.MapPath("~/App_Data/backup/TextComponents.xml"));
classSerializer.Serialize(classComponentWriter, _db.TextComponents.ToList());
classComponentWriter.Close();

restore:

List<TextComponent> TextComponents = null;
XmlSerializer TextComponentSerializer = new XmlSerializer(typeof(List<TextComponent>));
FileStream TextComponentFileStream = new FileStream(Server.MapPath("~/App_Data/backup//TextComponents.xml"), FileMode.Open);
TextComponents = (List<TextComponent>)TextComponentSerializer.Deserialize(TextComponentFileStream);

foreach (TextComponent item in TextComponents)
{
_db.TextComponents.Add(item);
}
_db.SaveChanges();

Raheel Khan · Accepted Answer · 2015-04-12 09:55:45Z

1

You can use reflection to enumerate all DBSet properties:

properties = typeof(DBContext).GetProperties(); // or this.GetType().GetProperties();

foreach (PropertyInfo property in properties)  
{  
    if (/*Check if property type is DBSet by comparing [property.DeclaringType](http://msdn.microsoft.com/en-us/library/system.type.declaringtype.aspx)*/)  
        // Write backup or restore code here.  
}

`

edited Apr 12, 2015 at 9:55

answered May 8, 2012 at 15:46

Raheel Khan

14.8k16 gold badges88 silver badges173 bronze badges

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

Collectives™ on Stack Overflow

Entity framework Code-First - backup and restore DbContext

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