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

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


Posted By:      Posted Date: October 06, 2010    Points: 0   Category :Sql Server


First, I realize that Visual Studio 2010 SP1 is supposed to add support for SSCE 4.0 (CTP) and that it should be released by the end of the year.  Like many others, I'd like to start using the entity framework with this new version now if possible to avoid more work later.  So far I've been able to create an SSCE 4 DB file (in code) and add tables/constraints/etc using my entity's ObjectContext.CreateDatabaseScript() method.  Now that the DB is created is there some way to put together a special EntityConnection and pass that into my entity model's constructor so that everything in the model works against this new DB file...at least in code (I don't care about in the designer right now)? 

Hopefully that all makes sense :)



View Complete Post

More Related Resource Links

Multiple statements in SSCE 3.5 SP2?

Hi all, I'm just wondering whether it's possible at all to execute multiple statements & multiple heterogeneous statements using the semicolon (";") separator.  SSCE balks at it right now if I issue via ADO.NET command text similar to the following (line separator is your typical \r\n): insert into Foo (id, name) values (1, 'foo1'); insert into Bar (id, name) values (1, 'bar1'); update Goo g set g.name = 'Goo1', g.fooId = 1, g.barId = 1 where id = 1; SQL Server Management Studio executes it just fine, which led me to believe that I could do it via ADO.NET. Can someone who knows please clarify?  What do I have to do in order to batch commands to ADO.NET? Thanks, Matthew

The path is not of a legal form - SSCE 3.5 and VS 2008 Server Explorer

Hi, I am facing one issue continuously whenever I try to open LocalDatabaseCache(.sdf files) in VS 2008. It says,"The path is not of a legal form". Even if test connection is succeeded. When I restart VS 2008 and DatabaseEngine service then only it opens the Database. Also sometimes I face problem of memory corrupt. May I know what could be the reason for this issue?  How can I permanently resolve it? Regards, Nandkishore    

Will SSCE install "kill" apps?


I hope I'm in the right forum for SSCE? 

I'm a student developing with VB and trying to incorporate a DataBase into my project.
I'm using a Lenovo ThinkPad T61, VISTA Business, and Visual Basic 2008 Express Edition.

There is a folder containing SSCE already on my machine.  It's titled "Microsoft SQL Server Compact Edition".  I think it was loaded by some app like my wireless modem.  I say this because when I uninstalled SSCE via Control Panel's "Add/Delete" (I didn't think it was needed) the wireless modem quit.  I fixed this from a full back-up.

My question is, if I install SSCE with the download from MS (SSCERuntime-ENU-x86.msi), will the install overwrite the current copy (I think yes) and cause the apps that are using the current copy to stop working?

Also, is there a "Management Studio" version that works with Compact Edition?

SSCE T-SQL for Transactions (Begin...End;): Does it exist?


I'm currently trying to optimize my mobile application by consolidating a collection of update and insert statements into a single stored procedure (or transaction) on my mobile device.  However, when I issue the SqlCeCommand, I consistently get an error stating that the first parameter is a mistype (this is a stored procedure).  I tried issuing the same command in the SQL CE Query Browser and it would fail in a similiar fashion.

Any tips on how to go about this without making a direct SqlCommand to the main SQL Server 2008 servers? (I'm using replication.)

SSCE TMP database files


I'm having a bit of trouble finding information related to usage of TMP temporary database files.

Specifically I'm trying to to determine when the SSCE engine would determine they are no longer used and delete them. We need to know whether we will need to manually remove the files.

I'm working with SSCE 3.5 SP2 on a desktop app, specifying the temp folder in the connection string.

Any insight?

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