.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

Entity Framework + SQL server 2008 compact edition: limitation?

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

any limitation with SQL Server 2008 compact edtion with Entity Framework 4?



View Complete Post

More Related Resource Links

SQL server 2008 compact editioin + Entity Framework: Can we backup the SQL server compact edition da

our application uses the SQL server 2008 compact edition and entity framework. The application will control the instrument. It may run for several days before it stops. In order to protect the database crash (database failure), we plan to backup SQL compact database during running. Can we backup or duplicate the ~.sdf when application is running? Is there any SQL server command we can call inside the application to achive the backup? Or we only can backup the database when application is not running. thx!  

SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing

I am attempting to install SQL Server 2008 Developer Edition on my laptop.  I already have VS 2008 SP1 installed and the .NET Framework 3.5 SP1 installed on my machine.  When I run setup.exe, it fails saying the .NET Framework 3.5 installation failed and that .NET Framework 3.5 is required for the installation.  I obviously have this already on my machine.  What's the problem and how do I get this to install?  Below is the text in my SqlSetup.log file:

10/10/2008 13:22:25.453 ======================================================================
10/10/2008 13:22:25.515 Setup launched
10/10/2008 13:22:25.546 Attempting to determine media source
10/10/2008 13:22:25.562 Media source value not specified on command line argument.
10/10/2008 13:22:25.578 Setup is launched from media directly so default the value to the current folder.
10/10/2008 13:22:25.609 Media source: C:\Downloads\en_sql_server_2008_developer_x86_x64_ia64_dvd_x14-88839\
10/10/2008 13:22:25.640 Attempt to determine media layout based on file 'C:\Downloads\en_sql_server_2008_developer_x86_x64_ia64_dvd_x14-88839\mediainfo.xml'.
10/10/2008 13:22:25.703 Media layout is detected as: Full
10/10/2008 13:22:25.718 Media LCID is detected as: 1033
10/10/2008 13:22:25.734 Local setup.exe not found, so continuing to run setup.exe from media.

Go Mobile: Create Compact, Robust Mobile Apps with SQL Server CE 2.0 and the .NET Compact Framework


Developers have myriad options when it comes to creating solutions for mobile devices. One of the greatest challenges facing mobile developers is finding a compact yet robust local storage solution. SQL Server CE 2.0 promises to deliver on both fronts. This new release represents a tremendous leap in terms of features and performance over its predecessor. This article will review some of the platform and tools choices developers have today. The authors will compare and contrast the significant new features in SQL Server CE 2.0 with the previous release. Following that, they will build a sample app for illustration.

Mark Brown and David Meunier

MSDN Magazine January 2003

MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

SQL Server 2008 - Installation Woe - .NET Framework 3.5 SP1

On a Windows 2003 R2 x64 server, I have been unable to install SQL Server 2008 Enterprise Edition x64. When running setup.exe, I almost instantaneously receive the following Microsoft SQL Server Setup error:"Microsoft .NET Framework 3.5 installation has failed.SQL Server 2008 Setup requires .NET Framework to be installed."What does not make sense is that I successfully downloaded .NET Framework 3.5 from the Microsoft download site (published 8/11/2008) prior to the SQL Server 2008 installation attempt.http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=enI do need to note that a few nights ago, prior to downloading the framework (3.5 SP1), I ran the SQL Server 2008 setup executable. I was prompted that in order to install SQL Server 2008, the setup program needed to first install .NET 3.5 SP1 and Windows Installer 4.5. I let the .NET 3.5 SP1 install run for about 1.5 to 2 hours and cancelled (now I wish I had just let it go).It is my understanding (correct me if I am wrong) that the SQL Server 2008 setup program initially checks for any pre-RTM versions of .NET 3.5 SP1 Framework. If one is found, it is then supposed to guide the user through both the installation of the .NET 3.5 SP1 Framework and Windows Installer 4.5. I have removed .NET 3.5 SP1 Framework (Add/Remove programs) and rebooted. However, upon runni

ODBC Driver for SQL Server Compact Edition

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5.  Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?   The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file.  This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.   Mario Cardinal MVP Solutions Architect

SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

sql server 2008 R2 Developer Edition

I am having trouble finding a place to actually purchase the developer edition of Sql Server 2008 R2. I went to CDW and they provide the ability to purchase a developer license but don't provide the actual software. Where can I actually purchase the developer edition without subscribing to MSDN? Thanks Royal

Server-side validation on an Entity Framework required field (property) does not work!

Has anyone had issues getting server-side validation on an Entity Framework required field (property) to work? The data type is a string (nvarchar). Server-side validation for required fields of other data types WORK fine. Only string fields have issues. I get the following error on UpdateModel(obj); of my POST method within the controller. Exception Details: System.Data.ConstraintException: This property cannot be set to a  null value.Source Error: Line 4500:                OnTextChanging(value);Line 4501:                ReportPropertyChanging("Text");Line 4502:                _Text = StructuralObject.SetValidValue(value, false);Line 4503:                ReportPropertyChanged("Text");Line 4504:                OnTextChanged(); I've even tried data annotations like this but it seems to get ignored.     [MetadataType(typeof(ObjMD))]     public partial class Obj     {    

SQL Server 2008 R2 Developer Edition

I've been looking to get SQL Server 2008 R2 Developer Edition since I discovered that there was going to be one.  My question is, where do i get it?  I can't find any place that references a place to buy it, or upgrade to it.  Any ideas?

Connection to Exchange Server of .NET 1.1 Framework application on Windows 2008 64-bit

I am running Visual Studio 2003 .NET Framework 1.1 application on Windows 2008 64-bit machine. There is only one problem - connection to Exchange Server. The same application is running fine on Windows 7 64-bit machine (not server). I tried to use the same Interop.MAPI.dll I used for Windows 7, but it doesn't work for Windows 2008.   Please help.  

SP 2010 and Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition

Hello,Will it be possible to install SharePoint 2010 on Windows 2008 R2 Web Edition and SQL Server 2008 Web Edition?Thanks

VS 2010: no Entity Framework or LINQ support for SQL Server 2000 SQLOLEDB connection?

Hello, I'm working with Visual Studio 2010 and for Data Connections am connecting to a SQL Server 2000 production database. When I try to drag a table to a .dbml file, the Object Relational Designer says, "The selected object(s) use an unsupported data provider."If I try to create an .edmx file via Generate from database, then the alert is, "This server version is not supported. You must have Microsoft SQL Server 2005 or later."So VS 2010 has no support for the Data Entity Framework or LINQ when connecting to a SQL Server 2000 database? If that is the case, what is the best data access strategy for this scenario?  

Error connecting to Remote report server database in SQL Server 2008 R2 DataCenter Edition

I am trying to configure my report server installed on Server A to point to a reporting services DB on Server B. I am able provide the name and test the connection. However, when i click next on the configuration wizard after providing the Server A name I am receiving the below error: The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services I have SQL Server 2008 R2 DataCenter Edition on both the servers.    

how many open connection is recommended to leave - in sql server 2008 Enterprise Edition

hi i have my C# program that work with sql-server 2008 Enterprise Edition i have 40 users that connect to this database. i dont close the connection. how many open connection is recommended to leave ? or is it better to close connection ? thank's in advance
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