How do I set the maximum database size when using Entity Framework?

Question

I am using Entity Framework and SQL CE 4.0 with my WPF application. How do I set the maximum database size in accordance with this article, http://blogs.msdn.com/b/sqlservercompact/archive/2007/06/13/the-story-of-max-database-size-connection-string-parameter.aspx which states:

we don't always grow to 4 GB, it is not wise to allocate shared memory to accommodate all page entries/references to support 4 GB.

Currently, I get the following error when trying to add new data:

The database file is larger than the configured maximum database size.

However, the DB is only reaching close to 256MB, which is in line with the article in the link above.

marc_s · Accepted Answer · 2011-11-02 06:01:45Z

8

This seems to work:

SqlCeConnectionFactory sqlCeConnection = 
    new SqlCeConnectionFactory("System.Data.SqlServerCe.4.0", 
    "", "Max Database Size=4000;Persist Security Info=False;");
DbDatabase.DefaultConnectionFactory = sqlCeConnection;
DbDatabase.SetInitializer(new SampleData());

Where the third parameter is the connection string and you change the parameter Max Database Size otherwise it defaults to 256MB.

edited Nov 2, 2011 at 6:01

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 2, 2011 at 3:30

Seth

8,37315 gold badges77 silver badges105 bronze badges

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

Comments

Tom Hunter · Accepted Answer · 2012-08-09 22:15:09Z

6

Alternatively using the app.config:

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
        <parameters>
            <parameter value="System.Data.SqlServerCe.4.0"/>
            <parameter value=""/>
            <parameter value="Max Database Size=4000"/>
        </parameters>
    </defaultConnectionFactory>
</entityFramework>

answered Aug 9, 2012 at 22:15

Tom Hunter

5,96011 gold badges54 silver badges80 bronze badges

Collectives™ on Stack Overflow

How do I set the maximum database size when using Entity Framework?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related