Showing posts with label SQLCE. Show all posts
Showing posts with label SQLCE. Show all posts

Tuesday, February 28, 2012

SQL Server 2012 LocalDB, SQL Express, SQL Compact Edition, side by side table style...

Jerry Nixon - SQL Express v LocalDB v SQL Compact Edition

"LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines.

Localdb is a minified version of SQL Express that require less number of pre-req to install and offers a fast, zero-configuration installation. – Chirag Shah

In SQL Server "Denali" we decided to change the approach and introduce a dedicated version of SQL Express for developers - LocalDB that delivers the simplicity and yet is compatible with other editions of SQL Server at the API level.

LocalDBManager.exe was the original name of the tool. Just before shipping CTP3 we decided to change the name to SqlLocalDB.exe, since LocalDBManager.exe seemed a little bit over the top for a simple command line tool. "Manager" part of the name suggests something much more comprehensive than SqlLocalDB.exe, something like the old SQL Server Enterprise Manager or IIS Manager. - Krzysztof Kozielczyk

Also, by making LocalDB a better SQL Express for developers, we hope to be able to improve the regular SQL Express to be a better free SQL Server. We'd be very happy to hear your feedback in this area, especially if you're using SQL Express as a database server and find any issues caused by the new features that were introduced to fit the needs of developers and desktop environment.

..."

Everything SQL Server Compact - Comparison of SQL Server Compact, SQL Server Express 2008 R2 and LocalDB

"Now that SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2008 R2.

I have updated the comparison table from the excellent discussion of the differences between Compact 3.5 and Express 2005 here to reflect the changes in the newer versions of each product.

Information about LocalDB comes from here and “Denali” CTP3 Books Online. LocalDB is the full SQL Server Express engine, but invoked directly from the client provider. It does not support Fulltext Search, and I doubt it support Merge Replication. It is a replacement of the current “User Instance” feature in SQL Server Express

SNAGHTML47dda2dc

image..."

While the chart is a few months old now, I still thought it outstanding seeing this kind of comparison, as I have the same questions, i.e. "What's the diff?" Now I'm in a better place... lol :)

I'm sure Erik will update this post (or create a new one) when SQL Server 2012 RTM's next month (March), so make sure you keep an eye on his blog...

 

Related Past Post XRef:
SQL Server Compact 4 vs SQL Server Express 2008 R2 Side-by-side feature comparison

Denali CTP3 introduces LocalDB - Think SQL Server Express crossed with SQL CE (or SQL CE grown up or SQL Express made as almost as easy CE)

Thursday, July 14, 2011

Denali CTP3 introduces LocalDB - Think SQL Server Express crossed with SQL CE (or SQL CE grown up or SQL Express made as almost as easy CE)

InfoQ - LocalDB: A Lightweight SQL Express for Developers

"As part of SQL Denali CTP3, Microsoft has included a new version of SQL Express called Local Database Runtime (LocalDB). It offers many of the same features as SQL Express, but installs faster, has fewer prerequisites, and doesn’t require management of a database instance.

LocalDB is meant to be an easier way for developers to get a SQL Express database up and running with minimal configuration or management, but it can also be used in production if it suits the needs of an application. Because it opens as a file with exclusive use, LocalDB is not appropriate for server-based or multi-user environments.

LocalDB fully supports T-SQL, and uses the same client-side providers as other versions of SQL Server (ADO.NET, ODBC, etc). It runs in-process, rather than as a service. When an application connects to LocalDB, the provider checks to see if it’s already running, and if not, will start it up and connect. The connection closes automatically after a few minutes of inactivity. ..."

SQL Server Express WebLog - Introducing LocalDB, an improved SQL Express

"Introduction

It gives me great pleasure to introduce a new version of SQL Express called SQL Express LocalDB.

LocalDB is created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express. In effect the developers that target SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops and other development machines. Moreover, if the simplicity (and limitations) of LocalDB fit the needs of the target application environment, developers can continue using it in production, as LocalDB makes a pretty good embedded database too.

...

High-Level Overview

After the lengthy introduction it's time to take a look at LocalDB from the technical side. At a very high level, LocalDB has the following key properties:

  1. LocalDB uses the same sqlservr.exe as the regular SQL Express and other editions of SQL Server. The application is using the same client-side providers (ADO.NET, ODBC, PDO and others) to connect to it and operates on data using the same T-SQL language as provided by SQL Express.
  2. LocalDB is installed once on a machine (per major SQL Server version). Multiple applications can start multiple LocalDB processes, but they are all started from the same sqlservr.exe executable file from the same disk location.
  3. LocalDB doesn't create any database services; LocalDB processes are started and stopped automatically when needed. The application is just connecting to "Data Source=(localdb)\v11.0" and LocalDB process is started as a child process of the application. A few minutes after the last connection to this process is closed the process shuts down.
  4. LocalDB connections support AttachDbFileName property, which allows developers to specify a database file location. LocalDB will attach the specified database file and the connection will be made to it.

...

LocalDB and SQL Server Compact?

Small and simple database, lightweight installation, connecting to a database file -- this will sound familiar to any developer using SQL Server Compact. The similarities are not accidental, as our goal for LocalDB was to be as easy to use as SQL Server Compact (while being as powerful and compatible with full SQL Server as SQL Express).

There are significant differences between LocalDB and SQL Server Compact:

  1. Execution mode: SQL Server Compact is an in-proc DLL, while LocalDB runs as a separate process.
  2. Disk usage: all SQL Server Compact binaries amount to some 4MBs, while LocalDB installation takes 140MBs.
  3. Features: SQL Server Compact offers core RDBMS functionality like querying, while LocalDB provides a much richer set of features, including Stored Procedures, Geometry and Geography data types, etc.

..."

Interesting... Kind of mixing the best of both worlds. In my mind, one key will be the installation/deployment for LocalDB. But I dig the direction this is going. I love the thought of having a full power SQL Server available to my app without dealing with some of the gunk SQL Server Express requires (and personally I hate having that service always running).

This is another Denali feature I'll be keeping an eye on...

 

Related Past Post XRef:
SQL Server Denali Sequence Object Overview
A couple SQL Server ColumnStore references...
Time to start thinking about, and providing feedback on, what you’ll need to upgrade to Denali (aka next version of SQL Server)

Thursday, May 26, 2011

SQL CE on Windows Phone 7.1 tips from an ISV (Linq, connection strings and creating/updating your DB's schema)

ComponentOne Community - Rich Dudley - Notes on Local SQL CE Databases and WP 7.1 “Mango”

"Introduction

In Windows Phone 7.1 Beta “Mango” tools, support for a local relational database in a client application was added. This database is based on SQL CE 4, and is stored in the application’s isolated storage (see image below). Databases need to be designed in a code-first pattern, using POCOs (plain old CLR objects) to define and create the database. It would be tempting to create a SQL CE 4 database in our project, and include it in the XAP, but then this database would be an embedded resource, not a local database, and XAP file size would be increased (not even our XapOptimizer minimizer/obfuscator could help you with the database). Since databases are not included with our application download, we need to include code to populate it with any seed data. The MSDN documentation for working with local databases starts at http://msdn.microsoft.com/en-us/library/hh202865(v=VS.92).aspx.

...

Linq-to-SQL is used to set the database context and query the local database in a Windows Phone 7 application. The Mango implementation of Linq-to-SQL is an incomplete version of that used in the full CLR. The implementation seems to be complete enough for most data-centric applications, but Linq-to-SQL masters might find some of the missing functionality a step backwards.

Because space is limited on a WP7 device, there are limits to our database’s size. The default maximum database size is 32 MB, and the maximum allowable size is 512 MB. If more space is needed, especially if images are involved, it might be time to think about storing data in Azure. Sharding might be possible, but probably wouldn’t be a best practice on a phone.

Linq-to-SQL on Windows Phone

...

Connection Strings and the Data Context

...

Creating the Database

...

Updating the Database

...

image..."

I liked how this post brought together a number of SQL CE on WP7 points that we'll likely run into in the real world...

Tuesday, May 17, 2011

Using the Microsoft Desktop Stack Series (Think “SQLCE 4, EF4, WPF, MVVM Three Part Series”)

CodeProject - Using the Microsoft Desktop Stack Series (Part 1, 2,3)

“This series describes how to create modern desktop applications using the Microsoft Desktop Stack -- WPF, Entity Framework 4, and SQL Server Compact Edition 4. The series covers creating a WPF app designed around the MVVM pattern, integrating WPF with Entity Framework 4, using Entity Framework 4.

Microsoft has revamped its desktop application stack in the past few years, moving from WinForms to WPF, from ADO.NET to the Entity Framework, and from the Jet database engine to SQL Server Compact Edition. This series of articles explains how to use the stack and presents checklists for implementing it.

The series consists of three articles:

Parts 1 and 2 contain checklists for setting up SQL Compact and Entity Framework for a desktop application. Part 3 shows how to integrate Entity Framework 4 into a WPF application using the MVVM pattern. The demo app is included with Part 3. The series assumes the developer is working with Visual Studio 2010 (VS 2010), Entity Framework 4.0 (EF 4), and SQL Server Compact Edition 4.0 (SQL Compact 4).

…”

I thought this an interesting series in that it starts with deployment, creating the setup/MSI. That’s pretty unusual…

Then there’s the SQLCE/EF pair which I’ve used a while ago and need a refresher. And having WPF/MVVM is a great topping… :)

Sunday, January 23, 2011

SQL Server Compact 4 vs SQL Server Express 2008 R2 Side-by-side feature comparison

Everything SQL Server Compact - Comparison of SQL Server Compact 4 and SQL Server Express 2008 R2

”Now that SQL Server Compact 4 has been released, some developers are curious about the differences between SQL Server Compact 4.0 and SQL Server Express 2008 R2.

I have updated the comparison table from the excellent discussion of the differences between Compact 3.5 and Express 2005 here to reflect the changes in the newer versions of each product

image…”

I like this quick and simple side-by-side comparison of SQL CE4 vs SQL Express 2008 R2. A good initial stop if you’re trying to decide between the two…

Wednesday, October 27, 2010

SQL Compact 4.0 CTP + NuPack = Painless project package plus’age

Everything SQL Server Compact - SQL Compact 4.0 now available as a .zip file

“With the recent release of NuPack beta, SQL Server Compact 4.0 CTP is now available as a .zip file. a feature requested by many users: since SQL Server Compact is just a collection of DLL files, why do you need to install an MSI to get hold of these DLL files.

NuPack has the purpose of simplifying the process of incorporating third party libraries into a .NET application during development. An introduction to NuPack is available here.

You can download the NuPack add-in here.

Once you have downloaded the add-in, you can add the SQLCE package from the References context menu in Solution Explorer, using the new “Add Package Reference” dialog:

download…”

Yeah, I know… “plus’age?” I spent way to long looking for a better way to tie up the title and just gave up, deal with it… LOL :P

 

Related Past Post XRef:
I “Nu” I needed you… NuPack v1 Developer Preview/CTP 1 Released (Think, “Where have you been all my dev life… finally an package management system/installer for .Net”)
New background on NuPack - A little about how it came about…

The “SQL Server Compact Edition Toolbox” VS2010 extension adds some very nice tasting frosting to your SQL CE Dev experience

Wednesday, September 22, 2010

The “SQL Server Compact Edition Toolbox” VS2010 extension adds some very nice tasting frosting to your SQL CE Dev experience

Sara Ford's Weblog - SQL Server Compact Toolbox – Extension #12

Today’s post comes from Guest Blogger Erik Ejlskov Jensen, SQL Server Compact MVP, @ErikEJ

Toolbox for SQL Server Compact developers

If you use SQL Server Compact, Microsoft’s embedded database for devices, desktops and soon ASP.NET, this extension is for you.

It adds several features not found in Server Explorer Data Connections:

  • Support for both version 3.5 and 4.0 database files
  • Script tables, including data
  • Script entire schema, optionally with data, both of SQL Server Compact and SQL Server 2005 or later databases
  • Import to SQL Server Compact from a SQL Server 2005/2008 database or a CSV file
  • Basic, free form query execution, with Excel friendly output
  • Parse SQL scripts
  • Display graphical estimated query plan
  • Generate detailed DGML files for visualizing table columns and relationships (requires VS 2010 Premium or higher to view)
  • Create and manage SQL Server Merge Replication subscriptions

download…”

I’m about to start into some personal SQL CE development so the timing on this couldn’t be much better.

Tuesday, June 08, 2010

Need just some parts and pieces of the SQL Server 2008 R2? Like SMO, the Native Client, Report Builder v3, the SQL CLR Types, JDBC/PHP/DB2 Driver, etc, etc? Then you need the “Microsoft® SQL Server® 2008 R2 Feature Pack”

Microsoft Downloads - Microsoft® SQL Server® 2008 R2 Feature Pack

“The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2.

File Name: SQL Server 2008 R2 Feature Pack.htm
Version: 10.50.1600.1
Date Published: 6/7/2010
Language: English
Download Size: 1 KB - 394.9 MB*


The Microsoft® SQL Server® 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2008 R2. It includes the latest versions of:

  • Redistributable components for Microsoft® SQL Server® 2008 R2.
  • Add-on providers for Microsoft® SQL Server® 2008 R2.

…”

Included in the SQL Server 2008 R2 Feature Pack are download links to;

  • Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2
  • Microsoft® SQL Server® PowerPivot for Microsoft® Excel
  • Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010
  • Microsoft® SQL Server® 2008 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2007
  • Microsoft® SQL Server® 2008 R2 Policies
  • Microsoft® Sync Framework 2.0 Software Development Kit (SDK)
  • Microsoft® SQL Server® Compact 3.5 SP2
  • Microsoft® SQL Server® Compact 3.5 SP2 For Windows Mobile
  • Microsoft® SQL Server ®Compact 3.5 SP2 Server Tools
  • Microsoft® SQL Server® Compact 3.5 SP2 Books On-line
  • Microsoft® SQL Server® JDBC Driver 3.0
  • Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2
  • Microsoft® System CLR Types for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Remote Blob Store
  • Microsoft® SQL Server® 2008 R2 Books On-line
  • Microsoft® SQL Server® 2008 R2 Upgrade Advisor
  • Microsoft® SQL Server® 2008 R2 Native Client
  • Microsoft® Core XML Services (MSXML) 6.0 SP 1
  • Microsoft® OLEDB Provider for DB2
  • Microsoft® SQL Server® 2008 R2 Command Line Utilities
  • Microsoft® SQL Server® Service Broker External Activator for SQL Server® 2008 R2
  • Microsoft® Windows PowerShell Extensions for SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Shared Management Objects
  • Microsoft® SQL Server® 2008 R2 ADOMD.NET
  • Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 R2
  • Microsoft® SQL Server® 2008 R2 Analysis Management Objects
  • Microsoft® SQL Server® 2008 Data Mining Add-ins for Microsoft® Office 2007
  • Microsoft® Datamining Viewer Controls For Microsoft® SQL Server® 2008
  • Microsoft® SQL Server® Driver for PHP 1.1
  • Microsoft® SQL Server® Migration Assistant
  • Microsoft® SQL Server® 2008 R2 Best Practices Analyzer

 

Related Past Post XRef:
SQL Server 2008 Feature Pack, August 2008 (i.e. The SQL2K8 RTM Feature Pack)

Monday, October 19, 2009

Microsoft Sync Framework v2.0 SDK and Redistributable RTM/RTW

Microsoft Downloads - Microsoft Sync Framework 2.0 Software Development Kit (SDK)

“Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services, and devices. Using Microsoft Sync Framework, developers can build applications that synchronize data from any source using any protocol over any network.

Version: V2RTM
Date Published: 10/18/2009
Language: English
Download Size: 35 KB - 146.3 MB*


Overview

Sync Framework 2.0 Overview
Sync Framework 2.0 expands on the capabilities offered by Sync Framework 1.0:

  • Adds features that cater to new scenarios or scenarios that were difficult to support.
  • Reduces the amount of work required to develop providers.
  • Supports more data sources with new built-in providers.
The major new features and improvements included in Sync Framework 2.0 are:
In Core Components:
  • Simple Providers: …
  • Flexible Filtering: …
  • Improved Conflict Handling: …
  • Data Conversion between Providers: …
  • Change Application Service:…
  • Tracing: …
In Database Providers:
  • New Database Providers (SQL Server and SQL Server Compact): Enable hub-and-spoke and peer-to-peer synchronization for SQL Server, SQL Server Express, and SQL Server Compact. …
  • Robust Memory-Based Batching: …
  • Provisioning and Management APIs: Provisioning and initialization activities that were previously exposed only through Visual Studio tooling have now been added to the database provider APIs….
  • Performance Improvements: The new database providers in this release have been thoroughly tested in large-scale scenarios in which a single server supports thousands of clients with hundreds of concurrent synchronization operations. …

Redistributable
To download the Microsoft Sync Framework 2.0 redistributables and bootstrapper, rather than the SDK package, click on the link: Microsoft Sync Framework 2.0 Redistributable Package

…”

Building your own synchronization is hard and that code is rarely a piece of core business functionality (sync may be but the code to do it rarely is). When/if I ever need to create my own sync’ing, this will be one of the first things I look at.

(via ActiveWin - Microsoft Sync Framework 2.0 Software Development Kit (SDK))

 

Related Past Post XRef:
Sync 101 - Samples for the Microsoft Sync Framework
Sync Framework v1 RTM’s (and includes ADO.Net Sync Services v2)
Using Microsoft Sync Framework in Visual Studio 2008 to Sync SQL Databases (SQL CE with SQL Server)
Microsoft Sync Framework CTP1 Released

Wednesday, August 06, 2008

SQL Server 2008 Feature Pack, August 2008 (i.e. The SQL2K8 RTM Feature Pack)

 Microsoft Downloads - Microsoft SQL Server 2008 Feature Pack, August 2008

“Download the 2008 Feature Pack for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008.

Version: 10.00.1600.22
Date Published: 8/6/2008
Language: English
Download Size: 1.0 MB - 318.6 MB*

The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of:

  • Redistributable components for SQL Server 2008.
  • Add-on providers for SQL Server 2008.
  • Backward compatibility components for SQL Server 2008.

Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Microsoft SQL Server 2005 Backward Compatibility Components

Microsoft SQL Server 2008 Command Line Utilities

SQL Server Compact 3.5 SP1

Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007

Microsoft SQL Server Driver for PHP 7

Microsoft Core XML Services (MSXML) 6.0

Microsoft SQL Server 2005 JDBC Driver 1.2 (Based on the description looks to also support SQL Server 2008)

Microsoft SQL Server 2008 Management Objects

Microsoft OLEDB Provider for DB2

SQL Server Remote Blob Store

Microsoft SQL Server 2008 Native Client

Microsoft SQL Server 2008 Policies

Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

Microsoft SQL Server System CLR Types

Microsoft Sync Framework

Microsoft SQL Server 2008 Upgrade Advisor

…”

So pretty much everything but the kitchen sink!

All available as stand-alone downloads (i.e. this isn’t some monster download but allot of smaller ones)

 

Related Past Post XRef:
SQL Server 2008 RTM Requires/Installs .Net 3.5 SP1 & Wait for VS2008 SP1 before you install SQL2K8 on your Dev machines
SQL Server 2008 Edition Side–by-side Feature Comparison - (aka. What Edition do I need so I can get feature X,Y or Z?)
SQL Server 2008 RTM’s (and is now available on MSDN Subscribers Download)

Wednesday, April 30, 2008

SQL Metal OSUI - A Visual Studio 2008 Addin, wrapping SQL Metal, to help you Linq to SQL Server Compact Edition 3.5 databases

CodePlex - SQL Metal Open Source User Interface

"This project provides an user interface for SqlMetal.exe tool.

SQLMetalOSUI allows users to generate code and mapping files for their SQL Server Compact Edition databases.

SQL Server Compact Edition 3.5 is fully compatible with LINQ to SQL but the designer does not. This project will be focused to reach this initial purpose.

...

for_Visual_Studio

..."

If you're Linq'ing to SQL CE 3.5 DB's often (or rarely and forget how to use SQLMetal) then this little VS Addin might come in handy for you...

 

Related Past Post XRef:
LINQ to Compact SQL

Friday, January 25, 2008

Being IN in LINQ to SQL - Or How I learned to Love Contains (aka Getting Linq to SQL to generate a T-SQL WHERE clause that includes an IN)

So today was my first time really playing with Linq to SQL (or any flavor of Linq for that matter). I'm prototyping a new feature and wanted to see how Linq could help...

The biggest road block? Trying to figure out how to do a IN in Linq to SQL, i.e. SELECT * FROM table WHERE column IN ('value','another','etc')

Dynamically building OR's wasn't going to cut it. (Linq: ... WHERE C.Column = "Value" or C.Column = "another" or C.Column = "etc" )

And using a Lambda expression in the Linq Where was making my brain hurt.

There had to be a simple and easy way to do this...

Luckily through the power of the search I found a hint for a truly workable and clean solution. One that results in final SQL that includes an IN. The Blomsma Code - LINQ to SQL: Joining database data with non-database data

 

The magic is with the Contains and to turn the Where on its head.

Here's an example (see the screenshots below).  The code pretty much speaks for itself.

The key is the order in the Where clause. I kept looking for an another method, another way, a more T-SQL kind of thing. Some way to say emp.Country IN bla bla or emp.Country.Contains(bla, bla), etc. But nothing would work or result in an IN based SQL Query... That is until I found the hint I needed in the above post.

Now the below code works exactly as I wanted. It builds a T-SQL statement using IN in the WHERE clause, is clean, scalable and easy to understand...

The source code and project is also available here, http://code.msdn.microsoft.com/LinqtoSQLJoinExample (but it's all below too... Yep, that's it, that's all of it... )

Source

Imports System.Data.Linq
Imports System.Data.SqlClient

Public Class Form1




Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim db As New Northwind("Data Source=C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\Samples\Northwind.sdf")
    Dim Countries() As String = Me.TextBox1.Text.Split(","c)
    Dim query = From emp In db.Employees _
Where Countries.Contains(emp.Country) _
Select emp
    db.Log = Console.Out
    Me.DataGridView1.DataSource = query
  End Sub
End Class

Screenshots


image


image


image


image


image


T-SQL Generated by Linq to SQL


SELECT [t0].[Employee ID] AS [EmployeeID], [t0].[Last Name] AS [LastName], [t0].[First Name] AS [FirstName], [t0].[Title], [t0].[Birth Date] AS [BirthDate], [t0].[Hire Date] AS [HireDate], [t0].[Address], [t0].[City], [t0].[Region], [t0].[Postal Code] AS [PostalCode], [t0].[Country], [t0].[Home Phone] AS [HomePhone], [t0].[Extension], [t0].[Photo], [t0].[Notes], [t0].[Reports To] AS [ReportsTo]
FROM [Employees] AS [t0]
WHERE [t0].[Country] IN (@p0)
-- @p0: Input String (Size = 0; Prec = 0; Scale = 0) [USA]
-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.21022.8



SELECT [t0].[Employee ID] AS [EmployeeID], [t0].[Last Name] AS [LastName], [t0].[First Name] AS [FirstName], [t0].[Title], [t0].[Birth Date] AS [BirthDate], [t0].[Hire Date] AS [HireDate], [t0].[Address], [t0].[City], [t0].[Region], [t0].[Postal Code] AS [PostalCode], [t0].[Country], [t0].[Home Phone] AS [HomePhone], [t0].[Extension], [t0].[Photo], [t0].[Notes], [t0].[Reports To] AS [ReportsTo]
FROM [Employees] AS [t0]
WHERE [t0].[Country] IN (@p0, @p1)
-- @p0: Input String (Size = 0; Prec = 0; Scale = 0) [USA]
-- @p1: Input String (Size = 0; Prec = 0; Scale = 0) [UK]
-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.21022.8



SELECT [t0].[Employee ID] AS [EmployeeID], [t0].[Last Name] AS [LastName], [t0].[First Name] AS [FirstName], [t0].[Title], [t0].[Birth Date] AS [BirthDate], [t0].[Hire Date] AS [HireDate], [t0].[Address], [t0].[City], [t0].[Region], [t0].[Postal Code] AS [PostalCode], [t0].[Country], [t0].[Home Phone] AS [HomePhone], [t0].[Extension], [t0].[Photo], [t0].[Notes], [t0].[Reports To] AS [ReportsTo]
FROM [Employees] AS [t0]
WHERE [t0].[Country] IN (@p0)
-- @p0: Input String (Size = 0; Prec = 0; Scale = 0) [UK]
-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.21022.8



SELECT [t0].[Employee ID] AS [EmployeeID], [t0].[Last Name] AS [LastName], [t0].[First Name] AS [FirstName], [t0].[Title], [t0].[Birth Date] AS [BirthDate], [t0].[Hire Date] AS [HireDate], [t0].[Address], [t0].[City], [t0].[Region], [t0].[Postal Code] AS [PostalCode], [t0].[Country], [t0].[Home Phone] AS [HomePhone], [t0].[Extension], [t0].[Photo], [t0].[Notes], [t0].[Reports To] AS [ReportsTo]
FROM [Employees] AS [t0]
WHERE [t0].[Country] IN (@p0, @p1)
-- @p0: Input String (Size = 0; Prec = 0; Scale = 0) [France]
-- @p1: Input String (Size = 0; Prec = 0; Scale = 0) [UK]
-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.21022.8



SELECT [t0].[Employee ID] AS [EmployeeID], [t0].[Last Name] AS [LastName], [t0].[First Name] AS [FirstName], [t0].[Title], [t0].[Birth Date] AS [BirthDate], [t0].[Hire Date] AS [HireDate], [t0].[Address], [t0].[City], [t0].[Region], [t0].[Postal Code] AS [PostalCode], [t0].[Country], [t0].[Home Phone] AS [HomePhone], [t0].[Extension], [t0].[Photo], [t0].[Notes], [t0].[Reports To] AS [ReportsTo]
FROM [Employees] AS [t0]
WHERE [t0].[Country] IN (@p0, @p1, @p2)
-- @p0: Input String (Size = 0; Prec = 0; Scale = 0) [France]
-- @p1: Input String (Size = 0; Prec = 0; Scale = 0) [UK]
-- @p2: Input String (Size = 0; Prec = 0; Scale = 0) [USA]
-- Context: SqlProvider(SqlCE) Model: AttributedMetaModel Build: 3.5.21022.8

Sunday, December 23, 2007

LINQ to Compact SQL

CodeProject - Compact LINQ

untitled

"...

One of the challenges encountered by developers looking to get acquainted with LINQ to SQL, is how to use it with SQL Server Compact Edition (SSCE), version 3.5. We were told LINQ will work with SQL Server for now; with more providers on the way (possibly not until LINQ to Entities is released). However, if you try to drag some tables from a Compact Edition data connection onto a new LINQ to SQL designer canvas, you'll witness a nasty error dialog stating that the provider is not supported!

...

Figure 1: The dreaded "unsupported data provider" error in the LINQ to SQL designer.

More accurately, the SSCE provider is not supported by the LINQ to SQL designer. You can still use the command-line tool, SQLMetal, to generate your data entities, data access, and other ORM code. If you prefer command-line tools, you're all set. If you like the idea of a visual representation of your entities, there is still hope.

I recommend creating a batch file or PowerShell script to generate your file(s) via SQLMetal. This allows you the benefit of a quick execution when you inevitably need to re-generate your data access layer due to schema changes. I've included one for download as an example.

For our sample application, the command needed is fairly simple.

..."

This is a cool, fairly in-depth article (12 printed pages) on using LINQ to SQL as well as using SSCE (SQL Server Compact Edition) as the provider. That and I liked the logo... ;)

Sunday, November 04, 2007

Microsoft Sync Framework CTP1 Released

Microsoft Downloads - Microsoft Sync Framework CTP1

"... Microsoft Sync Framework is a comprehensive synchronization platform that enables collaboration and offline scenarios for applications, services and devices. Developers can build sync ecosystems that integrate any application, any type of data, using any protocol over any network.

The Microsoft Sync Framework provides a platform for taking web services and databases offline. In addition, it provides optimized P2P sync of any type of file including contacts, music, videos, images and settings. The extensible framework includes built-in support for synchronizing relational databases, NTFS/FAT file systems, Simple Sharing Extensions for RSS/ATOM, devices and web services.

Highlights

  • Add sync support to new and existing applications, services, and devices
  • Enable collaboration and offline capabilities for any application
  • Roam and share information from any data store, over any protocol, and over any network configuration
  • Leverage sync capabilities exposed in Microsoft technologies to create sync ecosystems
  • Extend the architecture to support custom data types including files

..."

Microsoft Downloads - Introduction to the Microsoft Sync Framework

"Throughout this document we will discuss the Microsoft Sync Framework which enables developers to create offline and collaboration scenarios for applications, services and devices.

...

The Microsoft Sync Framework includes all of the things required to integrate applications into an offline or collaboration based network, using the pre-created providers or writing new custom providers. This article outline some key concepts regarding synchronization providers, which will help you to understand how to create a provider.

..."

Microsoft Downloads - Microsoft Synchronization Services for ADO.NET v2.0 CTP1

"The download package contains the SQL Server Compact Edition 3.5 and Microsoft Synchronization Services for ADO.NET v2.0 CTP1

..."

Microsoft Downloads - Introducing Microsoft Sync Framework: Sync Services for File Systems Whitepaper

"Dive into the details of this new reusable Sync Services for Files Systems component we call simply, the File System Provider, along with enabled scenarios and sample code for getting started.

...

Towards this goal, we have developed a reusable provider for synchronizing the contents of file system directories on PCs and removable media such as USB thumb drives. In this article, I’ll cover the details of this new reusable Sync Services for Files Systems component we call simply, the File System Provider, along with enabled scenarios and sample code for getting started.

..."

Interesting... Added to my mental watch list.

Friday, April 06, 2007

Enterprise Library 3.0 - April 2007 Released

Microsoft Downloads - Enterprise Library 3.0 – April 2007

"This release of Enterprise Library includes: Caching Application Block, Cryptography Application Block, Data Access Application Block, Exception Handling Application Block, Logging Application Block, Policy Injection Application Block, Security Application Block and Validation Application Block.

..."

Another Enterprise Library release, another statement that I still want/mean to use it... ;)

Update 4/6/2007 @ 8:55AM PDT:

Here's some more good info on this release...

David Hayden [MVP C#] - Enterprise Library 3.0 Released

"...

You get a whole bunch of really awesome enhancements in this new version of Enterprise Library:


I have about 20 - 30 Enterprise Library 3.0 Tutorials as well as several Code Camp Presentation Slides and Demos.

..."

Related Past Post XRef:
Enterprise Library for .NET Framework 2.0 RTM (January 2006)
"Avanade Integration Pack for Microsoft Enterprise Library Released"
Enterprise Library MSN Messenger Log Listener
Enterprise Library Logging : Rolling Flat File Sink
Microsoft Enterprise Library Tutorials
Microsoft Enterprise Library WebCasts
Download details: Enterprise Library
Enterprise Library (New release of the patterns & practices Application Blocks)

Thursday, January 11, 2007

SQL Server 2005 Compact Edition RTW

Microsoft SQL Server 2005 Compact Edition Runtime

"... Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop as well as on mobile devices. SQL Server Compact Edition Runtime can be used to develop and deploy applications on desktop. ..."

Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit

"... SQL Server 2005 Compact Edition Developer SDK contains the files required for installing SQL Server 2005 Compact Edition on mobile devices, desktop and tablet PC. It also has the Help File, and the Header files for native development, and the Northwind sample application. ..."

Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1

"... The download is installed after the installation of Visual Studio 2005 SP1 and updates the Smart Device Development components in Visual Studio 2005 SP1 with the SQL Server 2005 Compact Edition design time UI/Dialogs, device CAB files, and includes new features like Click Once support. ..."

Microsoft SQL Server 2005 Compact Edition Server Tools

"... Microsoft SQL Server 2005 Compact Edition Server Tools updates the servers running IIS to support connectivity solutions from SQL Server 2005 Compact Edition database on a mobile device or a desktop or a tablet PC to database servers running SQL Server 2000 SP3a and above versions ..."

It's SQL CE RTW day... Yeah! Download links are all working (as of right now at least).

Why am I excited about this? Because I need an easily embedded database, that's cheap, easy, simple to deploy and doesn't force me to relearn a new DB system...

Related Past Post XRef:
SQL Server Compact Edition RTW Tomorrow (11 January, 2007)
SQL Server 2005 Compact Edition (aka SQL Server Everywhere) Downloads
Visual Studio 2005 : Prepare for SQL Server Everywhere

Wednesday, January 10, 2007

SQL Server Compact Edition RTW Tomorrow (11 January, 2007)

SQL Server Everywhere Blog - SQL Server Compact Edition Release To Web (RTW)

"Hi,

SQL Server Compact Edition will be released to web on 11th January 2007.

For Runtime binary, we will be refreshing RC1 link hence RC1 bits will not be availble on web on Jan 10th.

We will be releasing following packages in 10 languages (English, chinese -simplified, chinese - traditional, spanish, korean, japanese, french, german, russian and italian);

SSCE Runtime
SSCE Developer SDK
SSCE Server tools
SSCE tools for VS 2005 SP1 and
SSCE Books on line

Thanks
Sachin" [Post leached in full]

So tomorrow is SQLCE day... yeah!

I'm spec'ing a project now where I plan to use this, so the timing is pretty darn good...

I'll post the RTW download links as soon as I get them.

Related Past Post XRef:
SQL Server 2005 Compact Edition (aka SQL Server Everywhere) Downloads
Visual Studio 2005 : Prepare for SQL Server Everywhere

Friday, December 15, 2006

SQL Server 2005 Compact Edition (aka SQL Server Everywhere) Downloads

SQL Server Compact Edition Runtime

"SQL Server 2005 Compact Edition includes a Microsoft Windows Installer (.msi) file. The .msi file installs redistributable components to a specific location on the destination computer. To ensure serviceability and technical support, use the .msi file to deliver software components. Please see Redist.txt included in the package for component information.

SQL Server 2005 Compact Edition can be installed by running the installer - SQLServerCE31-EN.msi. Installing SQL Server 2005 Compact Edition by running SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). Doing this ensures that the components can be serviced in future by Microsoft Update..."

SQL Server 2005 Compact Edition Server Tools

"Microsoft SQL Server 2005 Compact Edition Server Tools installs the SQL Server 2005 Compact Edition Replication Components on the IIS box. The components are required for connecting the SQL Server 2005 Compact Edition database on a mobile device or a desktop or a tablet PC to a SQL Server database that are SQL Server 2000 SP3a, SQL Server 2000 SP4, SQL Server 2005, or SQL Server 2005 SP1 database....

SQL Server 2005 Compact Edition Developer SDK

"Microsoft SQL Server 2005 Compact Edition (SQL Server 2005 Compact Edition) is designed for developers who need light weight, in process relational database solution for their applications that can be developed and deployed on desktop, tablet PC and mobile devices.

  • CAB files for installing SQL Server 2005 Compact on mobile devices
  • MSI file for installing SQL Server 2005 Compact Edition on desktop and tablet PC
  • Header files required for developing a native SQL Server Compact application
  • MSI for installing the SQL Server 2005 Compact Edition Help Files
  • Northwind sample application

"

More fun stuff to play with... I still which SQL 2005 CE supported SP's and triggers, but even without it's pretty darn cool and will be better than Access for many local host DB related projects.

Related Past Post XRef:
Visual Studio 2005 : Prepare for SQL Server Everywhere

Monday, January 16, 2006

"Windows Mobile Dev Kit"

Download details: Windows Mobile Dev Kit

"Everything you need, all in one place. With this kit, you'll have everything you need to start developing for Windows Mobile 2003 and Windows Mobile 5.0-based devices. Learn about Windows Mobile. Install the developer tools. Access technical resources. Tap into the developer community. Learn how to certify your applicaiton and become an industry partner.

What's inside? Tools and Technologies. Visual Studio 2005 Profesional Edition (90-day trial), Windows Mobile 5.0 SDKs for Pocket PC and Smartphone, ActiveSync 4.1, .NET Compact Framework 2.0, SQL Server CE and SQL Server 2005 Mobile Edition, Localized emulator images and other useful developer tools. Developer Resources: Links to technical white papers and webcasts, WeFly247-50 sample application, Hands-on labs and videos, Partnering opportunities.
"

I hope to pick up a Treo 700w "real soon now" so I'm keyed to Windows Mobile 5 news...

(I've been holding off, waiting for new phone where I can leverage my .Net experience, has a full keyboard and is based on the lastest Windows Mobile OS... Now all I have to do is pony up the funds...)

I've already installed much of the above stuff, but having it all in one download is pretty cool. Plus the labs and video's sound cool.