Archived Support Site

This support site is archived. You can view the old support discussions but you cannot post new discussions.

SLQ CE 4

Nick

23 May, 2011 04:21 AM

Hi,

Firstly, love the site and you have all done an excellent job, well done.

I am using SQLCE 4.0 to demonstrate a web site, would it be possible to install the provider on your servers?

Here is my site http://locationviewer.apphb.com/.

Thanks,

Nick

  1. #1 Posted by friism Support staff on 23 May, 2011 05:42 AM

    Relying on the instance filesystem is a bad idea because changes are not persisted across deploys nor between instances (if your app runs on multiple instances). We have a sample that demonstrates using CE for unit tests. You should be able to adapt that to your website, without requiring us to install the actual provider.

    Let us know if you hit any snags, and please post a blog post or similar if you get it working.

  2. friism closed this discussion on 23 May, 2011 05:42 AM.

  3. Nick re-opened this discussion on 23 May, 2011 06:44 AM

  4. #2 Posted by Nick on 23 May, 2011 06:44 AM

    Michael,

    Thanks for the quick response. The issue is I am using Entity Framework 4.1 and it requires funky connections strings.
    e.g.

    Is there any other way around you could think off?

    Also, for some reason your link did not work in Chrome since it was receiving a certificate revocation request. It did work in IE, very strange.

    Thanks again,

  5. #3 Posted by Nick on 23 May, 2011 06:46 AM

    looks like your feedback site takes out tags (sorry, should have pressed preview) here it is with out html tags:

    add name="LocationsEntities" connectionString="metadata=res:///Models.LocationModel.csdl|res:///Models.LocationModel.ssdl|res://*/Models.LocationModel.msl;provider=System.Data.SqlServerCe.4.0;provider connection string="Data Source=|DataDirectory|\Locations.sdf"" providerName="System.Data.EntityClient"

  6. #4 Posted by friism Support staff on 23 May, 2011 04:18 PM

    For entity framework, you cannot currently rely on the connectionstrings AppHarbor inserts. You can either hard-code them in your web.config, or (better) use web.config tranfsformations.

  7. friism closed this discussion on 23 May, 2011 04:18 PM.

  8. friism re-opened this discussion on 23 May, 2011 04:18 PM

  9. #5 Posted by friism Support staff on 23 May, 2011 04:18 PM

    And remember that, per default, only the App_Data folder is writeable by your app, so you should store database files there.

  10. friism closed this discussion on 23 May, 2011 04:18 PM.

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac