Tag: sqlce

With the official RTM release of Visual Studio 2012 and the MVC 4 project (also available for VS 2010), I have been using some of the features of new features and out of the box features of hte MVC 4 project to ease the development of my user stories.

SQL CE 4 made database backends much simpler by allowing developers to utilize a SQL engine even if you don’t have it installed on your computer and the zero-config usage is great. SQL CE does have some its limitations and the OAuthWebSecurity class exposes one such limitation: Transasction Scopes.

Given a development environment with a SQL CE 4 database, you can register a number of authentication providers such as Facebook and Google out of the box with no issues.

The limitation materializes when trying to disassociate the authentication provider (in this case, Google) from the base account. If you are using SQL CE 4 and the code made available to you with the out of the box ASP.NET MVC 4 project, you will get the following error when attempting to disassociate the account with the OAuth provider.

The connection object can not be enlisted in transaction scope.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: The connection object can not be enlisted in transaction scope.

Original Post

I have built an ASP.NET project using SQL CE 4.0 and Entity Framework 4.1. When the time came to deploy the web application to our managed environment, I ran into some issues due to some missing references.

Do to the nature of our hosted environment, installing the EntityFramework and SQLCE4 libraries was not an option but I have worked out all of the required steps to get the web application working in the deployed environment.

Web.config

On my development box, the machine.config has been modified (when I installed SQL CE 4) to include the SQL CE 4 provider. To use the provider without explicitly installing it on the server, we need to manually add the provider in the Web.config

You can provide am id attribute to the and update the link to the page with #{id}. foo And update the link to the page with the focused element to http://www.example.com/mypage#focus If you have a link on the same page (on a navigation section, for example) you can just use foo to jump to the […]

It looks like their /shareArticle endpoint ignores query string parameters. The official share url for the video you YouTube is https://youtu.be/4wDVzjn9s9E and https://www.linkedin.com/sharing/share-offsite/?url=https://youtu.be/4wDVzjn9s9E seems to achieve what you're trying to do.

What you're asking about is polymorphism. In your scenario, you can achieve this by providing a default implementation in your abstract class (as a virtual method) and them allowing each sub-class to provide their own implementation by overriding the method. In SpaceshipController, change protected void updateSpaceshipMovement() to protected virtual void updateSpaceshipMovement(). This is telling the […]