The answer is yes: Microsoft is silently dropping support (as usual IMHO) to Sql Compact Edition.

It started abandoning Sql CE 3.5 in Vs2012
It continued dropping Sql CE in Sql Management Studio 2012
and finally in VS2013

You can use [CompactView][1] or install SQL [Server Compact Toolbox][2] extension in VS2013 or (my prefered solution) use [Sql management Studio 2008][3]

UPDATE thanks to [Nicolas&#39; comment][4]

As [stated by Microsoft][5]:

&gt; SQL Server compact edition is in deprecation mode with no new releases
&gt; planned near future. Last release SQL CE 4.0SP1 (and earlier releases
&gt; that are still in the support cycle) will continue to be supported
&gt; through its lifecycle and Microsoft is committed to fix any major,
&gt; production blocking issues found in these releases. 


  [1]: http://sourceforge.net/projects/compactview/
  [2]: http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1
  [3]: http://www.microsoft.com/en-us/download/details.aspx?id=7593
  [4]: https://stackoverflow.com/questions/18598506/is-microsoft-dropping-support-for-sdf-database-files-in-visual-studio/19561391?noredirect=1#comment33507209_19561391
  [5]: http://connect.microsoft.com/SQLServer/feedback/details/776328/port-sql-compact-to-windows-rt#ctl00_MasterBody_upCommunityComments

I want to have a website where I can upload images of different sizes to be displayed in a jquery slider.
I can&#39;t seem to fit (scaling down) the image in a containing div. Here&#39;s how I&#39;m intending to do it

    &lt;!DOCTYPE html PUBLIC &quot;-//W3C//DTD XHTML 1.0 Transitional//EN&quot; &quot;http://www.w3.org    /TR/xhtml1/DTD/xhtml1-transitional.dtd&quot;&gt;
    &lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
    &lt;head&gt;
    &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot; /&gt;
    &lt;title&gt;Untitled Document&lt;/title&gt; 
    &lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; href=&quot;Imtest.css&quot;/&gt;
    &lt;/head&gt;

    &lt;body&gt;

    &lt;div id=&quot;wrapper&quot;&gt; 

    &lt;div id=&quot;im&quot;&gt;&lt;img src=&quot;Images/Scarpa2_1.jpg&quot; /&gt;&lt;/div&gt;

    &lt;/div&gt;  
    &lt;/body&gt;
    &lt;/html&gt;

And the CSS

    #wrapper {
        width: 400px;
        height: 400px;
        border: 2px black solid;
        margin: auto;
    }

    #im {
        max-width: 100%;
    }
	
I&#39;ve tried to set the max-width of my image to 100% in CSS. But that doens&#39;t work. 

CSS scale down image to fit in containing div, without specifing original size

I have 2 columns in my `GridLayout`. What I want to do is make those columns take up half of the width of the screen each and then have its child contents fill their own cells width/height. I tried setting the children to `fill_parent` but that just causes the first one to take over the entire layout. And it seems GridLayout doesn&#39;t support `weight`? Maybe there is a better layout to use, but I want a Grid style layout so that seems like the natural choice.

GridLayout Column width

In Visual Studio 2013 there is no longer an option to create `.sdf` SQL Server Compact databases in WebPages (WebMatrix) websites. I am no longer able to view `.sdf` database files in Visual Studio either. I downloaded the latest version of WebMatrix to open my `.sdf` database but WebMatrix crashes when I open my website. When I create a new empty site and add existing files, it crashes.

I searched for days for a way to view and edit my `.sdf` database and nothing is working. I can no longer get Navicat SQL Server app to open a database. I cannot get LinqPad to open an `.sdf` database file, I cannot get Compact Viewer to open or edit `.sdf` databases. I **can** _open_ `.sdf` databases with `SqlCEToolbox40.exe` but it only shows top 200 rows **and** it won&#39;t let me edit the tables.

Now I&#39;m completely stumped. How do I view **and** edit a `.sdf` database file?

Is Microsoft dropping support for SDF database files in Visual Studio?

In Visual Studio 2013 there is no longer an option to create <code>.sdf</code> SQL Server Compact databases in WebPages (WebMatrix) websites. I am no longer able to view <code>.sdf</code> database files in Visual Studio either. I downloaded the latest version of WebMatrix to open my <code>.sdf</code> database but WebMatrix crashes when I open my website. When I create a new empty site and add existing files, it crashes.
I searched for days for a way to view and edit my <code>.sdf</code> database and nothing is working. I can no longer get Navicat SQL Server app to open a database. I cannot get LinqPad to open an <code>.sdf</code> database file, I cannot get Compact Viewer to open or edit <code>.sdf</code> databases. I can open <code>.sdf</code> databases with <code>SqlCEToolbox40.exe</code> but it only shows top 200 rows and it won't let me edit the tables.
Now I'm completely stumped. How do I view and edit a <code>.sdf</code> database file?

`ERROR:  could not open extension control file &quot;/usr/share/postgresql/9.1/extension/postgis.control&quot;: No such file or directory`

Is what I get when I try to `CREATE EXTENSION postgis;` can anybody tell me why is it so and what can I do to fix it?

PostgreSQL error when trying to create an extension

4 items:

    A
    B
    C
    D

6 unique pairs possible:

    AB
    AC
    AD
    BC
    BD
    CD

What if I have 100 starting items? How many unique pairs are there? Is there a formula I can throw this into?

How do I get the total number of unique pairs of a set in the database?

I have read **Database system concepts**, 6th edition, *Silberschatz*. I&#39;m going to implement the university database system shown in chapter 2 on OS X on MySQL. But I have a trouble with creating the table `course`. the table `department` looks like

    mysql&gt; select * from department
        -&gt; ;
    +------------+----------+-----------+
    | dept_name  | building | budget    |
    +------------+----------+-----------+
    | Biology    | Watson   |  90000.00 |
    | Comp. Sci. | Taylor   | 100000.00 |
    | Elec. Eng. | Taylor   |  85000.00 |
    | Finance    | Painter  | 120000.00 |
    | History    | Painter  |  50000.00 |
    | Music      | Packard  |  80000.00 |
    | Physics    | Watson   |  70000.00 |
    +------------+----------+-----------+

    mysql&gt; show columns from department
        -&gt; ;
    +-----------+---------------+------+-----+---------+-------+
    | Field     | Type          | Null | Key | Default | Extra |
    +-----------+---------------+------+-----+---------+-------+
    | dept_name | varchar(20)   | NO   | PRI |         |       |
    | building  | varchar(15)   | YES  |     | NULL    |       |
    | budget    | decimal(12,2) | YES  |     | NULL    |       |
    +-----------+---------------+------+-----+---------+-------+

Creating the table `course` causes the following error.

    mysql&gt; create table course
        -&gt; (course_id varchar(7),
        -&gt; title varchar (50),
        -&gt; dept_name varchar(20),
        -&gt; credits numeric(2,0),
        -&gt; primary key(course_id),
        -&gt; foreign key (dept_name) references department);
    ERROR 1215 (HY000): Cannot add foreign key constraint

after searching google for foreign key constraint, I have just learned that the word &#39;foreign key constraint&#39; indicates that data from foreign key column in the table `course` must exist in primary key column in the table `department`. But I should have met this error when inserting data.   

If not, why does author make me execute that SQL statement? 

If I really execute erroneous SQL statement, Does I have to designate `dept_name` in course table as foreign key after inserting some data?




**EDIT** : typing `set foreign_key_checks=0` into `mysql&gt;` does not fix the error.

    ------------------------
    LATEST FOREIGN KEY ERROR
    ------------------------
    2013-09-21 16:02:20 132cbe000 Error in foreign key constraint of table university/course:
    foreign key (dept_name) references department):
    Syntax error close to:
    )
    mysql&gt; set foreign_key_checks=0
        -&gt; ;
    Query OK, 0 rows affected (0.00 sec)
    mysql&gt; create table course
        -&gt; (course_id varchar(7),
        -&gt; title varchar(50),
        -&gt; dept_name varchar(20),
        -&gt; credits numeric(2,0),
        -&gt; primary key(course_id),
        -&gt; foreign key (dept_name) references department);
    ERROR 1215 (HY000): Cannot add foreign key constraint


MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint

I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a &quot;bak&quot; file. I do this by overwriting an existing database. In the &quot;Options&quot; page, there is a check-box labeled &quot;Close existing connections to destination database&quot;, which I mostly check because the target database is always &quot;in use&quot;, even if I just restarted the MS SQL Service and I am sure that there are no applications using it. 

Anyway, on my client&#39;s computer, I saw that that checkbox to close existing connections is grayed out without any information. How and why does this happen? A google search didn&#39;t yield any results.

Why is &quot;close existing connections to destination database&quot; grayed out on SQL Server 2012 Management Studio?

I am currently trying to backup an empty SQL Server 2008 R2 database that I designed for a project that is getting shelved for the time being. I was going through the back up procedure through the SQL Management Studio when I noticed there was an option to make a Copy Only Back Up. I looked it up to see what it was but I didn&#39;t fully understand the options I was getting. 

http://technet.microsoft.com/en-us/library/ms191495.aspx

  I read the entry above as well as other entries and I keep seeing the phrase &quot;independent of the sequence of conventional SQL Server backups.&quot;

Can anyone elaborate what this statement means or more about Copy Only Backups in general? I&#39;m not sure if it&#39;s the backup I should do in this case? (My first reaction is no)

What do these Copy Only Backup options mean?

In a C# solution, I added a existing project.  
After that, Visual Studio has added the following entry in other .csproj files:

    &lt;ItemGroup&gt;
        &lt;Service Include=&quot;{B4F97281-0DBD-4835-9ED8-7DFB966E87FF}&quot; /&gt;
    &lt;/ItemGroup&gt;

What&#39;s this for?  
Can I delete it?

What is &quot;Service Include&quot; in a csproj file for?

If you look [here][1] you will notice that this guy is showing the Entity Model Diagrams, I would like to know how I can create an Entity Model Diagram from my EntityFramework code first classes. 

It just gets frustrating trying to remember how everything links together just by looking at the code. 



  [1]: http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/creating-a-more-complex-data-model-for-an-asp-net-mvc-application

How do you create a visual model of EntityFramework code first

Visual Studio 2013 apparently has some nice slick Git integration.

However, after an hour of head-scratching with absolutely nothing making even the slightest bit of sense, I&#39;ve only been able to create a local repository and despite cloning a remote bitbucket repository I simply cannot find a way to publish to my remote repository.

I&#39;ve used TFS, Subversion, Perforce and just about everything else, but this is completely baffling, with no instructions and a completely un-intuitive user interface.

Any ideas anyone ?

Visual Studio 2013 and BitBucket

Probably between 25 and 50% of the times I build my solution, I see this:

&quot;[The operation you requested is taking longer than expected to complete. This dialog will close when the action completes.](http://i.imgur.com/UOtXUud.png)&quot;

I hate this window in ways I can&#39;t describe. It never resolves, the Cancel button is never enabled, and the only way to remedy it is to kill the devenv process and load up my entire solution again, knowing full well that I&#39;ve fixed nothing and I&#39;m equally liable to see the same thing when I attempt my build.

My solution is about 60 projects in total, which are mostly C# class libraries, with a few each of web applications, web services, and console applications. However, the problem persists even when building one slice of the codebase with the majority (50) of the projects unloaded.

My problem is that the output windows doesn&#39;t tell me anything at the point at which it freezes, and I don&#39;t know how else to determine the cause of this lockup. If I were to guess, I would assume that it&#39;s a deadlock in the filesystem or something, but I don&#39;t know how to go about proving this--much less how to prevent it.

What can I do to diagnose and eliminate this from my solution so that I never see it again? In general, how can I diagnose problems that occur during a build?

Visual Studio hangs constantly during build

Such as:

`The thread &#39;&lt;No Name&gt;&#39; (0x16b4) has exited with code 0 (0x0).`

When I am using the Output Window for my own data, the threading messages clutters it.

Is there a way to prevent Visual Studio from printing Thread exited statements into the Output Window?

when I tried to create a new SQL Server Compact file from Visual Studio -&gt; Add New Item, I don&#39;t see the &#39;Local Database&#39; option any more which was actually the way to add SQL Server Compact Database. Now, if it is really discontinued from Microsoft, then, what is the recommended Embedded Database technology from Microsoft for Desktop Applications ? I tried SQLite but deployment is headache for SQLite because, the user may not have correct version of Visual C++ distributable installed in his/her machine.  

Is SQL Server Compact discontinued from Visual Studio 2013?

I&#39;ve inherited C# code that has an awful lot of DateTimes where the Kind property is DateTimeKind.Unspecified.  These are fed into Datetime.ToUniversalTime() which gives back a UTC datetime (it adds 7 hours in my case). This is how ToUniversalTime() works; see MSDN.
 The problem is that these DateTimes are in fact already in UTC time.  They are pulled out of a SQL Server Compact 4.0 database.  They were stored there in UTC.  My main question is:

1.  How do I modify the Kind property of a DateTime so that it&#39;s UTC and not Unspecified?  I don&#39;t want to change the time or date.  So for example, a date of April 1st 2013, 9:05 am with its Kind property of &quot;Unspecified&quot; should become a datetime of April 1st 2013, 9:05 UTC.  

If I could be indulged with a follow up question(s), it would be:

2. Are values necessarily returned from Sql Server Compact as &quot;Unspecified&quot;?  Inside Sql Server Compact, they are being stored as type (datetime, not null).   Looking at the code, it appears they are just put in the database, but there are no provisions to mark them as UTC or anything.  Is there a better way to handle things?  Is there a slick way to ensure the DateTimes come out of SQL Compact as UTC?

Please let me know if I can provide more details.  I&#39;m new to this code base and still getting my brain around it, so I&#39;m having trouble describing the problem perfectly.

Dave

Content Type	Original Author	Original Content on Stackoverflow
Question	jAsOn	View Question on Stackoverflow
Solution 1 - Database	giammin	View Answer on Stackoverflow

Is Microsoft dropping support for SDF database files in Visual Studio?

Database Problem Overview

Database Solutions

Solution 1 - Database

GridLayout Column width

CSS scale down image to fit in containing div, without specifing original size

Attributions