There is some good info here: [Create a SQL Server Compact Edition Database with C#][1]

    string connectionString = &quot;DataSource=\&quot;test.sdf\&quot;; Password=\&quot;mypassword\&quot;&quot;;
    SqlCeEngine en = new SqlCeEngine(connectionString);
    en.CreateDatabase();


  [1]: http://arcanecode.com/2007/01/25/create-a-sql-server-compact-edition-database-with-c/

First, go click on the Browse tab. Now navigate to `C:\Program Files\Microsoft SQL Server Compact Edition\v3.1`. Now pick the `System.Dadta.SqlServerCe.dll`, click on it, then click on OK to pull in the reference. 

Now let’s write some code. First, go to the head of the class, whoops I mean header of your class and let’s create a using reference.  

    using System.Data.SqlServerCe;
    using System.IO;

      string connectionString;
      string fileName = &quot;aminescm.sdf&quot;;
      string password = “aminescm”;
 
      if (File.Exists(fileName))
      {
        File.Delete(fileName);
      }
 
      connectionString = string.Format(
        &quot;DataSource=\&quot;{0}\&quot;; Password=&#39;{1}&#39;&quot;, fileName, password);
      SqlCeEngine en = new SqlCeEngine(connectionString);
      en.CreateDatabase();

You can find more and more about this, it&#39;s really an amazing web site: 

http://arcanecode.com/arcane-lessons/

I looked into `C:\Program Files\Microsoft.NET` and I can&#39;t see any `SN.exe` file.

I have .NET 3.5 runtime installed; isn&#39;t that enough ?

Cannot find sn.exe to sign Assembly


I&#39;m trying to fix a problem with CRLF on Windows.

How do I see what the value of the configuration setting `core.autocrlf` is set to on my system?


How can I print out the value of a git configuration setting (core.autocrlf) on Windows?

How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?

Create SQL Server CE database file programmatically

<p>How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?</p>


When is it appropriate to throw an exception from within a property getter or setter? When is it not appropriate? Why? Links to external documents on the subject would be helpful... Google turned up surprisingly little.

Best practices: throwing exceptions from properties

I am converting a ticks value to a date like this:

    Convert(datetime, (MachineGroups.TimeAdded - 599266080000000000)/864000000000);

 
Using this i get:

    9/27/2009 10:50:27 PM

But I want just the date in this format:

    October 1, 2009

My sample ticks value is

    633896886277130000

What is the best way to do this?



How can I convert ticks to a date format?

given the following code:

    public static class Helpers
    {
       private static Char[] myChars = new Char[] {&#39;a&#39;, &#39;b&#39;};

       private static Int32 myCharsSize = myChars.Length;
    }

Is it guaranteed that `myChars` will be initialized *before* I use its length to assign to `myCharsSize`?

Initialization Order of Static Fields in Static Class

I am often comparing data in tables in different databases.  These databases do **not** have the same schema.  In TSQL, I can reference them with the  `DB&gt;user&gt;table` structure (`DB1.dbo.Stores`, `DB2.dbo.OtherPlaces`) to pull the data for comparison.  I like the idea of LINQPad quite a bit, but I just can&#39;t seem to easily pull data from two different data contexts within the same set of statements.

I&#39;ve seen people suggest simply changing the connection string to pull the data from the other source into the current schema but, as I mentioned, this will not do.  Did I just skip a page in the FAQ?  This seems a fairly routine procedure to be unavailable to me.

In the &quot;easy&quot; world, I&#39;d love to be able to simply reference the typed datacontext that LINQPad creates.  Then I could simply:

```csharp
DB1DataContext db1 = new DB1DataContext();
```

```csharp
DB2DataContext db2 = new DB2DataContext();
```

And work from there.

LINQPad, using multiple datacontexts

I am wondering how should I be grouping my repositories? Like from the examples I seen on the asp.net mvc and in my books they basically use one repository per database table. But that seems like a lot of repositories leading you to have to call up many repositories later on for mocking and stuff.

So I am guessing I should group them. However I am not sure how to group them.

Right now I made a registration Repository to handle all my registration stuff. However there are like 4 tables I need to update and before I had  3 repositories to do this.

For example one of the tables is a license table. When they register I look at their key and check it to see if exists in the database. Now what happens if I need to check this license key or something else from that table at some other spot other then registration?

One spot could be login(check if the key is not expired). 

So what would I do in this situation? Rewrite the code again(break DRY)? Try to merege these 2 repositories together and hope that none of the methods are needed in some other point of time(like maybe I might have a method that checks if userName is used - maybe I will need that somewhere else).

Also if I merge them together I would either need 2 service layers going to the same repository since I think having all the logic for 2 different parts of a site would be long and I would have to have names like ValidateLogin(), ValdiateRegistrationForm(),ValdiateLoginRetrievePassword() and etc.

Or call the Repository anyways and just have a weird sounding name around?

It just seems hard to make a repository that has a general enough name so you can use it for many spots of your application and still make sense and I don&#39;t think calling another repository in a repository would be a good practice?





How to use the repository pattern correctly?

I&#39;ve seen [pronunciation guides][1] and all sorts of definitions of .NET as a *framework*, but no definition or explanation of the actual *name* of the framework.

[Wikipedia][2] doesn&#39;t seem to know.  [This question][3] didn&#39;t cover it. 

Anybody know?  Is it pure marketing-generated nonsense, or does it mean something?


  [1]: http://msdn.microsoft.com/en-us/library/aa155747(office.10).aspx
  [2]: http://en.wikipedia.org/wiki/.net_framework
  [3]: https://stackoverflow.com/questions/165408/what-programming-acronyms-do-you-frequently-use-without-knowing-the-meaning-of

What does .NET stand for? Is it an acronym?

As the title says: do I need to override the `==` operator? how about the `.Equals()` method? Anything I&#39;m missing?

What needs to be overridden in a struct to ensure equality operates properly?

I have a stylistic question about the choice of background thread implementation I should use on a windows form app. Currently I have a `BackgroundWorker` on a form that has an infinite `(while(true))` loop. In this loop I use `WaitHandle.WaitAny` to keep the thread snoozing until something of interest happens. One of the event handles I wait on is a &quot;`StopThread`&quot; event so that I can break out of the loop. This event is signaled when from my overridden `Form.Dispose()`. 

I read somewhere that `BackgroundWorker` is really intended for operations that you don&#39;t want to tie up the UI with and have an finite end - like downloading a file, or processing a sequence of items. In this case the &quot;end&quot; is unknown and only when the window is closed. Therefore would it be more appropriate for me to use a background Thread instead of `BackgroundWorker` for this purpose?


BackgroundWorker vs background Thread

How do you say the following in Microsoft SQL Server 2005:

    IF EXISTS (SELECT * FROM Table WHERE FieldValue=&#39;&#39;) THEN
       SELECT TableID FROM Table WHERE FieldValue=&#39;&#39;
    ELSE
       INSERT INTO TABLE(FieldValue) VALUES(&#39;&#39;)
       SELECT TableID FROM Table WHERE TableID=SCOPE_IDENTITY()
    END IF

What I&#39;m trying to do is to see if there is a blank fieldvalue already, and if there is then return that TableID, else insert a blank fieldvalue and return the corresponding primary key.


IF EXISTS, THEN SELECT ELSE INSERT AND THEN SELECT

I have a stored procedure that returns rows:

    CREATE PROCEDURE MyProc
    AS
    BEGIN
    	SELECT * FROM MyTable
    END

My actual procedure is a little more complicated, which is why a stored procedure is necessary.

Is it possible to select the output by calling this procedure?

Something like:

    SELECT * FROM (EXEC MyProc) AS TEMP

I need to use `SELECT TOP X`, `ROW_NUMBER`, and an additional `WHERE` clause to page my data, and I don&#39;t really want to pass these values as parameters.


How to SELECT FROM stored procedure

According to BOL (SQL Server Books Online) on [`sp_dbcmptlevel`][1], &lt;br /&gt;

&gt; This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use ALTER DATABASE Compatibility Level instead.

Now, the only TSQL way I know of checking database compatibility is through `sp_dbcmptlevel`.
As far as I know, [`ALTER DATABASE Compatibility Level`][2] is just for **setting** the compatibility level, not getting info.

How should one to get compatibility level without using GUI?


  [1]: http://technet.microsoft.com/en-us/library/ms178653.aspx
  [2]: http://technet.microsoft.com/en-us/library/bb510680.aspx

How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

I am looking for a good SQL Statement to select all rows from the previous day from one table. The table holds one datetime column. I am using SQL Server 2005.


SQL statement to select all rows from previous day

I&#39;m converting a db from postgres to mysql. 

Since i cannot find a tool that does the trick itself, i&#39;m going to convert all postgres sequences to autoincrement ids in mysql with autoincrement value.

So, how can i list all sequences in a **Postgres** DB (**8.1** version) with information about the table in which it&#39;s used, the next value etc with a SQL query?

Be aware that i can&#39;t use the `information_schema.sequences` view in the 8.4 release.


List all sequences in a Postgres db 8.1 with SQL

From the [MySQL](https://www.mysql.com/) console, what command displays the schema of any given table?

How do I show the schema of a table in a MySQL database?

Is it possible to get a history of queries made in postgres? and is it be possible to get the time it took for each query? I&#39;m currently trying to identify slow queries in the application I&#39;m working on.

I&#39;m using Postgres 8.3.5

Is it possible to get a history of queries made in postgres

What is the best way to check if a table exists in MySQL (preferably via PDO in PHP) without throwing an exception. I do not feel like parsing the results of &quot;SHOW TABLES LIKE&quot; et cetera. There must be some sort of boolean query?

MySQL check if a table exists without throwing an exception

I have read the documentation (http://dev.mysql.com/doc/refman/5.1/en/partitioning.html), but I would like, in your own words, what it is and why it is used.  

  1. Is it mainly used for multiple servers so it doesn&#39;t drag down one server?
  2. So, part of the data will be on server1, and part of the data will be on server2. And server 3 will &quot;point&quot; to server1 or server2...is that how it works?
  3. Why does MYSQL documentation focus on partitioning within the same server...if the purpose is to spread it across servers?





What is MYSQL Partitioning?

I have an SDF file and I would like to retrieve its schema and query it with some UI. How can I do this? I have no Visual Studio installed on the machine and I would like to install as little software as possible.

How do you open an SDF file (SQL Server Compact Edition)?

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?

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;))



Content Type	Original Author	Original Content on Stackoverflow
Question	Andrew Arnott	View Question on Stackoverflow
Solution 1 - C#	D'Arcy Rittich	View Answer on Stackoverflow
Solution 2 - C#	aminescm	View Answer on Stackoverflow

Create SQL Server CE database file programmatically

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

How can I print out the value of a git configuration setting (core.autocrlf) on Windows?

Cannot find sn.exe to sign Assembly

Attributions