Sql Server Compact Edition

I've been playing with a workflow service hosted here http://www.briankeating.net/PSService/PSService.svc
Feel free to give it a bash [August 2012, removed]) Endpoint is using basic http binding.

Tonight I whipped a Sql Server Compact Database out of another little app I have lying around so I could sit it behind the webservice persist data.

But

To my horror it doesn't work..

I get the following exception " sql compact is not intended for asp.net development"

I can imagine why I guess.. bit what a pity.. it's not allowed..

[August 2012: It is allowed, just needs a setting]

Comments (1) -

brianbruff
brianbruff
1/27/2011 9:12:48 PM #

over one year later I was watching the key note at webcamps in belgium and noticed scott hanselman was saying that it can be used on a webserver!!!

time for a little investigation and sure enough, there's a solution.

AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);


Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

About the author

Brian Keating is a developer addicted to Microsoft Technologies.

Month List

Tag cloud

RecentComments

Comment RSS