Alex Rivera | Logout

Increase the size of sql compact 3.5 .sdf file

Asked 2010-03-09T11:02:48.147
20

I'm using Sql Compact3.5 as my DB with C# .NET what is the maximum size of sdf that I can give? Is there any way to programatically increase the maximum size of the sdf file? If so how?

c# sql-server-ce filesize
Edit
Report

1 Answer

6

As Benny Jobigan said, you can specify a maximum size via the connection string.

However, the size specified must be between 16 and 4091. If you specify a size outside if this, the following exception is thrown (from the C# SQL Server Compact 3.5 library):

System.ArgumentException: The value of ssce:max database size token is outside of range of allowed values (16,4091).

answered 2012-12-13T18:51:29.367

Your Answer