Today, June 12th, we released the first CTP of SQL Server Everywhere Edition (SSEv). www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&displaylang=enThe main SQL site will also be updated to include info on SQL Server Everywhere Edition: www.Microsoft.com/Sql/Everywhere
This release has a couple of key features:
To get a sense of the ease of use of the SqlCeResultset, try the following:
Me.DataGridView1.AutoGenerateColumns = TrueDim conn As New SqlServerCe.SqlCeConnection()conn.ConnectionString = "Data Source = |DataDirectory|\Northwind.sdf"Dim cmd As New SqlServerCe.SqlCeCommand()cmd.Connection = conncmd.CommandText = "SELECT * FROM Employees"conn.Open()Me.BindingSource1.DataSource = _ cmd.ExecuteResultSet(SqlServerCe.ResultSetOptions.Scrollable Or SqlServerCe.ResultSetOptions.Updatable)
Hit F5 and you now have a DataGridView that is databound to an updatable cursor. How simple and cool is that?
There’s plenty of cool things to do with SSEv. We’d love to hear the great projects you’ve developed.
I’m at Tech Ed this week giving several presentations and talking to as many developers as I can. I’ll post addition demos and info as the week goes on.
The SSEv team has been extremely busy creating this new MSI, creating the ClickOnce package, adding the DataDirectory macro and a host of other things we had to “fit & finish” before making the CTP available. We even have early, updated docs ready for download. The team has been really busy as they’ve got 10 other projects their currently working on as they still support the Mobile platform. Let the SSEv team know what you think at: http://blogs.msdn.com/sqlmobile They’re a great team that deserves a lot of credit for managing so much in so little time.