.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL CE 4.0 and C# Express 2010

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I have asked the question on the C# Express boards, but thought I might have better luck here...


Basically, I am writing a small Windows Forms app, with SQL CE as the backend.  I had been using SQL CE 3.5 SP2, but couldnt move forward due to the lack of support for the identity column in the ADO.NET Entity Framework.  This was supposedly fixed in CE 4.0 with VS 2010 SP1, both of which I have installed.  I also have SQL Server 2008 R2 Express installed.

However, when I try to create a new SQL CE DB in SQL Server Management Studio, the only option I get is 3.5.  I thought you should also now see 4.0? 

I have been looking at the following post: http://blogs.msdn.com/b/sqlservercompact/archive/2011/03/15/sql-server-compact-4-0-tooling-support-in-visual-studio-2010-sp1-and-visual-web-developer-express-2010-sp1.aspx

I am very confused by what I need to do to get this to work.

View Complete Post

More Related Resource Links

Visual Web Developer 2010 Express "Copy Web Site" using different login


I created a site and am trying to grant another pesron access to upload changes to it without giving them my super-user login.

I made a login for her but I can't test whether it works or not because no matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as my superuser account without prompting me for a login again.

How do I test is the account it set up correctly before having her try to upload to it?    I want to force the login to remote site dialog to pop up again to test her account.

Any ideas?

web sites made with visual webdeveloper express 2010


Good evening,

just a quick question, are there a lot of developers using  the express edition to make web sites, or is it limited to what you can do, and I would be  better getting the full edition visual studio 2010. I have been using dreamweaver, but I wanted to try my hand at asp.net, thx for any info you can offer.

MVB - 2010 - Express


Trying to do something that seems very simple but can not figure out how to do so. Fairly new to MVB Studio.

I am trying to query a SQL server that is already running(network / not local), using the wizard all the options I can find are to conenct to an .mdf and attach it to a server.  If need be I can create a Data source using an ODBC driver and query it at run time, but I can seem to figure out how to do this. (IE, something like office can do when you create queries in excel from an existing data source.)

SQL 2008 Express with advanced services and Visual studios 2010

Hi could someone please help me. Im running the following software: SQL 2008 Express R2 with advanced services Visual Studios 2010 Ultimate   I am trying to using Sql in Visual studios to use full text indexing but I am attaching a database that already exists. My problem is that I can use the full text indexing? I had it working once but then when i tried to FREETEXT search through my table it said that I didn't have an index on that table when I know I do cause I went to make sure. I think that perhaps its referencing the wrong database because I cant seem to add the database into my project? I am so confused as to how SQL express instances work so not sure what I am doing wrong? PLEASE HELP? 

vs 2010 Web Developer Express Limitations

What is the different between the vs 2010 Web Developer Express and the full version of 2010? With the vs 2010 Web Developer Express will I be able to use all types of databases (MSSQL, MySQL, Access, ect) and enitity frame work?

Building WCF appl in VS C# 2010 Express doesn't provide app.config when New Proj specified

Hey guys, I am trying to get my feet wet with the WCF environment. I was following a tutorial that wanted to alter the New Project Application that I tried to follow along with & when it came to making changes to the app.config file, it was nowhere to be found?! I tried a second time to start a new project using the WCF REST option and this time a rcv the following msg: **The project file 'J:\USER\TOMJ\APPDATA\LOCAL\TEMP\VC4TLPEZ.Y3X\TEMP\WCFRESTSERVICE4.CSPROJ' CANNOT BE OPENED. The project type is not supported by this installation. ??! ** IAm I missing something in my VS 2010 C# Express application? If so, someone please tell me how to resolve this problem.   Thanks in advance . . . TomJTom Johnson

Search Server Express 2010 - Access Denied when attempting to manage Search Service Application or P

I first noticed this error with the Search Service Application when I was no longer able to use the search portal, but have since noticed the issue with the PowerPoint Service Application.  When I navigate in Central Administration to either the "Farm Search Administration" or the "Manage service applications" pages and attempt to manage the "Search Service Application", I get this error: Error: Access Denied  Current User You are currently signed in as:  WHEELERS\MyUserName   Sign in as a different user    I have tried removing the service application and re-adding it, changing the application pool to running under an existing application pool as the farm administrator, as another application pool with the same identity as the primary web application, and as another application pool running under the SP-SearchService identity. The big recent change with SharePoint, aside from fixing the previous issue where I was incorrectly using CNAMEs with Kerberos, was to switch the main web application to claims authentication. That site correctly works with claims based authentication and Kerberos.

Installing Share Point 2010 and connecting it to an existing instance of sql 200r express r2

Hi i dont want share point server 2010 to create another instance of sql express 2008 r2, i want it to use the exiting one SQLEXPRESS but i dont know what installation option to do and what settings to do ? im installing share point 2010 on windows 2008 r2 server regards

how to make working WPF 2010 program make changes to SQL Server 2008 Express files

(1) I have a working WPF 2010 program that manipulates a table in SQL Server 2008 Express (2) the program does delete, update, select and insert correctly however in its own project file folder logbooklmk.mdf   logbooklmk_log.ldf (3) I want the actual SQL Server 2008 express files to be changed yes I know the issue is sharing and the copy option only applies to the local project files. I found this out by trying always copy, never copy and copy if newer. I probably have to change the .xsd folder to refer to the actual SQL Server 2008 Express file. Tried that once and it failed. Something about sharing not allowed.

Installing Share Point 2010 and connecting it to an existing instance of sql 200r express r2

Hi i dont want share point server 2010 to create another instance of sql express 2008 r2, i want it to use the exiting one SQLEXPRESS but i dont know what installation option to do and what settings to do ? im installing share point 2010 on windows 2008 r2 server regards

Microsoft Visual Web Developer 2010 Express Bugs?

UserControl_Normal is a user control I created, it works wells, but sometimes system occur the following error when I compile project. I have to restart my Windows XP in order to solve the problem.  Could you tell me how to do? Thanks!  Error 1 The type or namespace name 'UserControl_Normal' could not be found (are you missing a using directive or an assembly reference?) E:\ASP.NET4.0_Calculator\hicalc\UserControl\ShowCode.ascx.cs 258   

adding quicklinks/tree navigation to main search page (search 2010 express)

Hi Just installed Search Server 2010 Express (full version). On the previous version you could add the top link bar to the search page to easily allow you to browse to other sections i.e contacts. With 2010 I cannot seem to add any kind of navigation away from this main page (default.aspx). Using Designer it will not allow me to edit the top bar, quick launch, tree view and top link bar have been enabled with links however they do not show up on the main search page. can someone help ?

sbase.exe and vs 2010 express

how can i set up vs 2010 to use  the database program that ships with openoffice.org 3.1, I'm guessing I have to configure vs2010 to see sbase as a data provider or somthing. any help/suggestion/yourtime greatly appreciated  

SharePoint Search Server 2010 Express returns no search results for non-admin users

This is going to sound crazy, but anyway... bare with me... I have a SharePoint Search Server 2010 Express (RTM) installed with a crawl account (call it sharepoint_crawl) which has full read permission to an entire site collection of 100,000 documents. I have logged in with this account to make sure it has read access to everything, and it does. I run a full crawl of all documents and allow it to finish. If I try and search the content for an extremely common term (i.e. 50,000+ hits) I get no results. However, if I log in with a site collection admin I do get search results. There are no indexing errors or query errors in either log files or event log. Everything looks like it is working correctly - just no results for non-admins Anyone tripped on this? I have recreated the crawl account and perform a full re-index with the same results. What gets me is that the crawl account does have read permission to the content it is indexing, the content is indexed correctly, but the crawl account cannot get results back. It is as if security-trimming is removing everything. Any ideas?

VWD 2010 Express (and all VS 2010 Express) "Unable to attach debugger."

I have a problem similar to the one described here: http://forums.asp.net/p/1200680/2103206.aspx - but that was about VS 2008 RTM, and also a different error message.When I go to debug anything using any of the VS 2010 Express apps (under WinXP SP3 x86 with .NET 2 SP1, 3.0 SP1, 3.5 SP1, and 4.0 installed), I get an error alert box showing:"Unable to attach. The debugger is not properly installed. Cannot debug the requested type of code. Run setup to install or repair the debugger."I did a Repair on VWD 2010 Express, then another on .NET 3.5 (which includes .NET 2.0 SP1 and .NET 3.0 SP1), to no avail.From reading in other forums, I read advice on running the Debugger Diagnostics, which I did. It seemed to show no errors (all Return Codes were eight zeroes each).I also saw advice on running "regsvr32.exe" on the "mscordbi.dll" file found in my .NET 2 Framework folder (%windir%\Microsoft.NET\Framework\v.2.0.50727), and on a file in the V7DEBUG folder, which I did. The latter worked fine, but the former gives this alert:"mscordbi.dll was loaded, but the DllRegisterServer entry point was not found. | This file cannot be registered."In the thread I linked to, greggm suggested using FileVer (found on Windows 2000 and up CD-ROMs by installing the Support Tools) on the contents of the V7DEBUG folder. I did it to both that and the .NET Framework 2 folder as well, and re-directe

where can i download vwd 2010 express?

i once downloaded it from the express site but now i can not find it again.any idea?

Search Server 2010 Express databasename GUIDs

I installed SSE 2010 using the "Server Farm" option and default options. I note it created some 9 databases with names like: <normal name>_<GUID> I prefer not to have those GUIDs appear in the name.  It's easy enough to rename the sql databases but what has to be done on the SharePoint side to make it use the renamed databases ?     TIA, Barkingdog
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend