Try [LINQPad](http://www.linqpad.net/), it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0). Best of all it&#39;s free!

![LINQPad](http://i.stack.imgur.com/mPiBd.jpg)

Steps with version 4.35.1:

1. click &#39;Add Connection&#39;

2. Click Next with &#39;Build data context automatically&#39; and &#39;Default(LINQ to SQL)&#39; selected.

3. Under &#39;Provider&#39; choose &#39;SQL CE 4.0&#39;.

4. Under &#39;Database&#39; with &#39;Attach database file&#39; selected, choose &#39;Browse&#39; to select your .sdf file.

5. Click &#39;OK&#39;.

6. Voila! It should show the tables in .sdf and be able to query it via right clicking the table or writing LINQ code in your favorite .NET language or even SQL. How cool is that?

It&#39;s a SQL Compact database.  You need to define what you mean by &quot;Open&quot;.  You can open it via code with the SqlCeConnection so you can write your own tool/app to access it.  

Visual Studio can also [open the files directly][1] if was created with the right version of SQL Compact.  

There are also some [third-party tools][2] for manipulating them.


  [1]: http://arcanecode.com/2007/04/10/creating-a-sql-server-compact-edition-database-using-visual-studio-server-explorer/
  [2]: http://www.primeworks-mobile.com/Products/DataPortConsole.html

You can use SQL Compact Query Analyzer

[https://github.com/christianhelle/sqlcequery][1]

SQL Compact Query Analyzer is really snappy. 3 MB download, requires an install but really snappy and works.


  [1]: https://github.com/christianhelle/sqlcequery

In addition to the methods described by @ctacke, you can also open SQL Server Compact Edition databases with SQL Server Management Studio. You&#39;ll need SQL Server 2008 to open SQL CE 3.5 databases.

If you simply need to view the table and run queries on it you can use [this][1] third party sdf viewer. It is a lightweight viewer that has all the basic functionalities and is ready to use after install.

and ofcourse, its Free.


  [1]: http://www.softpedia.com/progDownload/SDF-Viewer-Download-146403.html

It can be opened using Visual Studio 2012.Follow the below path in VS after opening the project.
View-&gt;Server Explorer-&gt;

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/zymlI.png

I like how this works in Zend Framework. I can know which environment I&#39;m currently using by checking APPLICATION_ENV constant in my controller. 

    &lt;VirtualHost *:80&gt;
    	#ServerName 
    	#DocumentRoot
        
            SetEnv APPLICATION_ENV &quot;development&quot;
    
    	# Directory
    &lt;/VirtualHost&gt;

But unfortunately I can&#39;t use ZF in my current project. How can I check this environment variable in my PHP code?

Set Application_ENV via virtual host config and read this in PHP

I am trying to get xdebug working with eclipse (3.5) / php (on xampp windows 7).  I have verified xdebug is enabled in php - I have the fancy output and my phpinfo shows all the xdebug stuff.  I have remote debug on, and typed in the lan ip address on my eclipse machine.

When I tell eclipse to debug, it launches the browser and passes the debug URL parameters.  That looks OK.

However, in eclipse debug perspective it shows &#39;launching myproject&#39; 57%   &#39;waiting for xdebug session&#39;.   It sits there forever.

I have turned off windows firewall on both machines.

I tried turning implicit flush on.

Any ideas?


eclipse xdebug session never completes

I used to open sdf (sqlCE) files with visual-studio? or sql-server? I really don&#39;t remember.
Now I can&#39;t open this sdf file. With what program do I need to open it?

how to open *.sdf files?

<p>I used to open sdf (sqlCE) files with visual-studio? or sql-server? I really don't remember.
Now I can't open this sdf file. With what program do I need to open it?</p>


Is there a way to get all the querystring name/value pairs into a collection?

I&#39;m looking for a built in way in .net, if not I can just split on the &amp; and load a collection.

Is there a way to get all the querystring name/value pairs into a collection?

I am trying to pass array parameter to SQL commnd in C# like below, but it does not work. Does anyone meet it before? 

    string sqlCommand = &quot;SELECT * from TableA WHERE Age IN (@Age)&quot;;
    SqlConnection sqlCon = new SqlConnection(connectString);
    SqlCommand sqlComm = new SqlCommand();
    sqlComm.Connection = sqlCon;
    sqlComm.CommandType = System.Data.CommandType.Text;
    sqlComm.CommandText = sqlCommand;
    sqlComm.CommandTimeout = 300;
    sqlComm.Parameters.Add(&quot;@Age&quot;, SqlDbType.NVarChar);
    StringBuilder sb = new StringBuilder();
    foreach (ListItem item in ddlAge.Items)
    {
         if (item.Selected)
         {
             sb.Append(item.Text + &quot;,&quot;);
         }
    }

    sqlComm.Parameters[&quot;@Age&quot;].Value = sb.ToString().TrimEnd(&#39;,&#39;);



Pass Array Parameter in SqlCommand

How would you implement paging in a LINQ query? 
Actually for the time being, I would be satisfied if the sql TOP function could be imitated. However, I am sure that the need for full paging support comes up sooner later anyway.

    var queryResult = from o in objects
                      where ...
                      select new
                          {
                             A = o.a,
                             B = o.b
                          }
                       ????????? TOP 10????????



Paging with LINQ for objects

I have a Type, a String and an Object.

Is there some way I can call the parse method or convert for that type on the string dynamically?

Basically how do I remove the if statements in this logic

    object value = new object();    
    String myString = &quot;something&quot;;
    Type propType = p.PropertyType;
    
    if(propType == Type.GetType(&quot;DateTime&quot;))
    {
        value = DateTime.Parse(myString);
    }
 
    if (propType == Type.GetType(&quot;int&quot;))
    {
        value = int.Parse(myString);
    }

And do someting more like this.

    object value = new object();
    String myString = &quot;something&quot;;
    Type propType = p.PropertyType;


    //this doesn&#39;t actually work
    value = propType .Parse(myString);  






C#: Dynamic parse from System.Type

If I have an IEnumerable&lt;ClassA&gt; where ClassA exposes an ID property of type long.
Is it possible to use a Linq query to get all instances of ClassA with ID belonging to a second IEnumerable&lt;long&gt;?

In other words, can this be done?

    IEnumerable&lt;ClassA&gt; = original.Intersect(idsToFind....)?

where original is an `IEnumerable&lt;ClassA&gt;` and idsToFind is `IEnumerable&lt;long&gt;`.





Intersect LINQ query

## Original Problem ##

In building our projects, I want the mercurial id of each repository to be embedded within the product(s) of that repository (the library, application or test application).

I find it makes it so much easier to debug an application being run by customers 8 timezones away if you know precisely what went into building the particular version of the application they are using. As such, every project (application or library) in our systems implements a way of getting at the associated revision information.

I also find it very useful to be able to see if an application has been compiled with clean (un-modified) changesets from the repository. &#39;Hg id&#39; usefully appends a + to the changeset id when there are uncommitted changes in a repository, so this allows us to easily see if people are running a clean or a modified version of the code.

My current solution is detailed below, and fulfills the basic requirements, but there are a number of problems with it.

## Current Solution ##

At the moment, to each and every Visual Studio solution, I add the following &quot;Pre-build event command line&quot; commands:

    cd $(ProjectDir)
    HgID

I also add an HgID.bat file to the Project directory:

    @echo off
    type HgId.pre &gt; HgId.cs

    For /F &quot;delims=&quot; %%a in (&#39;hg id&#39;) Do &lt;nul &gt;&gt;HgID.cs set /p =            @&quot;%%a&quot;

    echo ;					&gt;&gt; HgId.cs
    echo     }				&gt;&gt; HgId.cs
    echo }					&gt;&gt; HgId.cs

along with an HgId.pre file, which is defined as:

    namespace My.Namespace {
    /// &lt;summary&gt; Auto generated Mercurial ID class. &lt;/summary&gt;
    internal class HgID {
        /// &lt;summary&gt; Mercurial version ID [+ is modified] [Named branch]&lt;/summary&gt;
        public const string Version =

When I build my application, the pre-build event is triggered on all libraries, creating a new HgId.cs file (which is not kept under revision control) and causing the library to be re-compiled with with the new &#39;hg id&#39; string in &#39;Version&#39;.

## Problems with the current solution ##

The main problem is that since the HgId.cs is re-created at each pre-build, so every time we need to compile anything, all projects in the current solution are re-compiled. Since we want to be able to easily debug into our libraries, we usually keep many libraries referenced in our main application solution. This can result in build times which are significantly longer than I would like.

Ideally I would like the libraries to compile only if the contents of the HgId.cs file have actually changed, as opposed to having been re-created with exactly the same contents.

The second problem with this method is it&#39;s dependence on specific behaviour of the windows shell. I&#39;ve already had to modify the batch file several times, since the original worked under XP but not Vista, the next version worked under Vista but not XP and finally I managed to make it work with both. Whether it will work with Windows 7 however is anyones guess and as time goes on, I see it more likely that contractors will expect to be able to build our apps on their Windows 7 boxen.

Finally, I have an aesthetic problem with this solution, batch files and bodged together template files *feel* like the wrong way to do this.

## My actual questions ##

How would you solve/how are you solving the problem I&#39;m trying to solve?

What better options are out there than what I&#39;m currently doing?

## Rejected Solutions to these problems ##

Before I implemented the current solution, I looked at Mercurials Keyword extension, since it seemed like the obvious solution. However the more I looked at it and read peoples opinions, the more that I came to the conclusion that it wasn&#39;t the right thing to do.

I also remember the problems that keyword substitution has caused me in projects at previous companies (just the thought of ever having to use Source Safe again fills me with a feeling of dread *8&#39;).

Also, I don&#39;t particularly want to have to enable Mercurial extensions to get the build to complete. I want the solution to be self contained, so that it isn&#39;t easy for the application to be accidentally compiled without the embedded version information just because an extension isn&#39;t enabled or the right helper software hasn&#39;t been installed.

I also thought of writing this in a better scripting language, one where I would only write HgId.cs file *if* the content had actually changed, but all of the options I could think of would require my co-workers, contractors and possibly customers to have to install software they might not otherwise want (for example cygwin).

Any other options people can think of would be appreciated.

----------
# Update #

## Partial solution ##

Having played around with it for a while, I&#39;ve managed to get the HgId.bat file to only overwrite the HgId.cs file if it changes:

    @echo off
    
    type HgId.pre &gt; HgId.cst

    For /F &quot;delims=&quot; %%a in (&#39;hg id&#39;) Do &lt;nul &gt;&gt;HgId.cst set /p =            @&quot;%%a&quot;
    
    echo ;					&gt;&gt; HgId.cst
    echo     }				&gt;&gt; HgId.cst
    echo }					&gt;&gt; HgId.cst
    
    fc HgId.cs HgId.cst &gt;NUL
    if %errorlevel%==0 goto :ok
    copy HgId.cst HgId.cs
    :ok
    del HgId.cst

## Problems with this solution ##

Even though HgId.cs is no longer being re-created every time, Visual Studio still insists on compiling everything every time. I&#39;ve tried looking for solutions and tried checking &quot;Only build startup projects and dependencies on Run&quot; in Tools|Options|Projects and Solutions|Build and Run but it makes no difference.

The second problem also remains, and now I have no way to test if it will work with Vista, since that contractor is no longer with us. 

 - If anyone can test this batch file on a Windows 7 and/or Vista box, I would appreciate hearing how it went.

Finally, my aesthetic problem with this solution, is even stronger than it was before, since the batch file is more complex and this there is now more to go wrong.

If you can think of any better solutions, I would love to hear about them.

Embedding mercurial revision information in Visual Studio c# projects automatically

I&#39;m building a report in Visual Studio 2008 with a lot of [multivalue parameters][1] and it&#39;s working great, but I would like to have have the &quot;(Select all)&quot; option as the default value when the report is opened. 

Is there some kind of expression or SQL code I can use to make this happen? Or do I need to choose &quot;(Select all)&quot; every time, in every parameter, each time I want to run the report?

  [1]: http://msdn.microsoft.com/en-us/library/aa337292%28v=sql.100%29.aspx

Select All as default value for Multivalue parameter

I&#39;m attempting to use the &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;R&lt;/kbd&gt;, &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;R&lt;/kbd&gt; command within Visual Studio 2008 to rename a variable.  I get an error message at the bottom saying that 

&quot;The key combination (&lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;R&lt;/kbd&gt;, &lt;kbd&gt;Ctrl&lt;/kbd&gt;+&lt;kbd&gt;R&lt;/kbd&gt;) is bound to command (&amp;Rename...) which is not currently available.&quot;

I am not running it or anything I can think of which might prohibit modifications of the file and the F2 command allows a rename to happen.  Anyone know how to fix this?

EDIT:  I do have Resharper installed but was previously able to do this with the same setup, I recently migrated computers.

Ctrl+R, Ctrl+R command not working

I want to merge one .NET DLL assembly and one C# Class Library project referenced by a VB.NET Console Application project into one command-line console executable.

I can do this with ILMerge from the command-line, but I want to integrate this merging of  reference assemblies and projects into the Visual Studio project. From my reading, I understand that I can do this through a MSBuild Task or a Target and just add it to a C#/VB.NET Project file, but I can find no specific example since MSBuild is large topic. Moreover, I find some references that add the ILMerge command to the Post-build event.

 1. How do I integrate ILMerge into a Visual Studio (C#/VB.NET) project, which are just MSBuild projects, to merge all referenced assemblies (copy-local=true) into one assembly?

 2. How does this tie into a possible ILMerge.Targets file?

 3. Is it better to use the Post-build event?

How to Integrate ILMerge into Visual Studio Build Process to Merge Assemblies?

How do I move a project to a different folder in Visual Studio? I am used to this structure in my projects.

    -- app
    ---- Project.Something
    ---- Project.SomethingElse

I want to rename the whole namespace SomethingElse to SomethingNew, what&#39;s the best way to do that (without manually going into .sln file)?

Visual Studio move project to a different folder

I&#39;m interested in choosing an embedded DB engine for my WPF app. I would like information on how SQLite and latest SQL CE 4.0 compare. And if I should choose one over the other. Points of interest would be ORM support with EF4&#39;s CTP &amp; NHibernate 3.

Thanks in advance!

SQL Server Compact 4.0 vs. SQLite

I&#39;m working with the Code First feature of Entity Framework and I&#39;m trying to figure out how I can specify the column data types that should be created when the database is auto-generated.

I have a simple model:

    public class Article
    {
        public int ArticleID { get; set; }

        public string Title { get; set; }
        public string Author { get; set; }
        public string Summary { get; set; }
        public string SummaryHtml { get; set; }
        public string Body { get; set; }
        public string BodyHtml { get; set; }
        public string Slug { get; set; }

        public DateTime Published { get; set; }
        public DateTime Updated { get; set; }

        public virtual ICollection&lt;Comment&gt; Comments { get; set; }
    }

When I run my application, a SQL CE 4.0 database is automatically created with the following schema:

![DB Schema][1]

So far, so good! However, the data I will be inserting into the `Body` and `BodyHtml` properties is routinely larger than the maximum allowed length for the `NVarChar` column type, so I want EF to generate `Text` columns for these properties.

However, I cannot seem to find a way to do this! After quite a bit of Googling and reading, I tried to specify the column type using `DataAnnotations`, from information found in [this answer][2]:

    using System.ComponentModel.DataAnnotations;

    ...

    [Column(TypeName = &quot;Text&quot;)]
    public string Body { get; set; }

This throws the following exception (when the database is deleted and the app is re-run):

    Schema specified is not valid. Errors: (12,6) : error 0040: The Type text is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.

But I have no idea what namespace or alias I should be specifying, and I couldn&#39;t find anything that would tell me.

I also tried changing the annotation as per [this reference][3]:

    using System.Data.Linq.Mapping;

    ...

    [Column(DbType = &quot;Text&quot;)]
    public string Body { get; set; }

In this case a database _is_ created, but the `Body` column is still an `NVarChar(4000)`, so it seems that annotation is ignored.

Can anyone help? This seems like it should be a fairly common requirement, yet my searching has been fruitless!


  [1]: http://i.stack.imgur.com/A4OI9.gif
  [2]: https://stackoverflow.com/questions/4829776/generate-money-type-fields-using-code-first-ef-ctp5/4833477#4833477
  [3]: http://msdn.microsoft.com/en-us/library/system.data.linq.mapping.columnattribute.dbtype.aspx

How do I specify that a property should generate a TEXT column rather than an nvarchar(4000)

In SQL Server Compact Edition in Visual Studio 2010 (maybe SQL Server and SQL in general, I don&#39;t know), this command works:

    DELETE FROM foods WHERE (name IN (&#39;chickens&#39;, &#39;rabbits&#39;))

but this command produces an error of: `Error near identifier f. Expecting OUTPUT.`

    DELETE FROM foods f WHERE (f.name IN (&#39;chickens&#39;, &#39;rabbits&#39;))



Why can&#39;t I use an alias in a DELETE statement?

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?

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.  

Content Type	Original Author	Original Content on Stackoverflow
Question	Gold	View Question on Stackoverflow
Solution 1 - C#	Chris Voon	View Answer on Stackoverflow
Solution 2 - C#	ctacke	View Answer on Stackoverflow
Solution 3 - C#	user_v	View Answer on Stackoverflow
Solution 4 - C#	Phil Ross	View Answer on Stackoverflow
Solution 5 - C#	Nikhil Sahu	View Answer on Stackoverflow
Solution 6 - C#	Hameed Syed	View Answer on Stackoverflow

how to open *.sdf files?

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

Solution 3 - C#

Solution 4 - C#

Solution 5 - C#

Solution 6 - C#

eclipse xdebug session never completes

Set Application_ENV via virtual host config and read this in PHP

Attributions