SQL Server Compact Edition under ASP.net and IIS

Julian Kuiters - What I'm Reading 28 Nov 2006

Julian Kuiters - What I'm Reading 28 Nov 2006 — Tue, 28 Nov 2006 07:43:37 GMT

PingBack from http://www.julian-kuiters.id.au/article.php/reading-2006-11-28

SQL Server CE Compact Edition

Smartymobile — Thu, 30 Nov 2006 06:14:19 GMT

Steve Lasker ha escrito un buen artículo sobre como usar SQL CE en ASP.NET . Joel Francia hace unas semanas

SQL Server CE Compact Edition

CesarFong — Thu, 30 Nov 2006 06:14:27 GMT

Steve Lasker ha escrito un buen artículo sobre como usar SQL CE en ASP.NET . Joel Francia hace unas semanas

re: SQL Server Compact Edition under ASP.net and IIS

Ed — Thu, 07 Dec 2006 11:41:56 GMT

I for one agree with the original intent of SQL Everywhere/Compact. It's an extremely useful tool and one that does not require so much from the client side.

I sincerely hope (and I'm confident) that your team will not be distracted by requests that ultimately harm the original intent, and therefore the product.

It's refereshing that you and your team do listen and do give workarounds (aka hacks), and hopefully they remain as such, hacks.

SQL Compact, just by it's moniker, should remain as such. No services, in proc. The Microsoft stack already provides the appropriate tools for alternative "server centric" use (ie. ASP.Net) as you have noted.

Thanks for your great work on this! We're close to completing our SQL Compact - hope to send you some "in the trenches" production use feedback soon!

Happy holidays!

re: SQL Server Compact Edition under ASP.net and IIS

Roger Jennings — Sat, 09 Dec 2006 21:32:21 GMT

Steve,

Slightly off-topic, but do you intend to post some of the code you wrote in your December 4 Webcast, "Live From Redmond: Visual Studio: Developing Local and Mobile Data Solutions with SQL Server Compact Edition?"

I think viewers would appreciate it.

(See http://oakleafblog.blogspot.com/2006/11/sql-server-2005-compact-edition-rc1.html)

Cheers,

--rj

re: SQL Server Compact Edition under ASP.net and IIS

Roger Jennings — Fri, 12 Jan 2007 21:50:00 GMT

The SQLce 3.1 Web release (RTM bits) is available at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=85e0c3ce-3fa1-453a-8ce9-af6ca20946c3&DisplayLang=en#QuickInfoContainer

--rj

re: SQL Server Compact Edition under ASP.net and IIS

Nathan Allan — Tue, 16 Jan 2007 10:14:40 GMT

To be frank, comments like "In future releases we are exploring using SQLce for mid-tier caching..." make me nervous. I've also seen references to the possibility that support for things like Stored Procedures may be added in the future. SQLce's single best feature is its compactness. Why add features that the higher end products already have, and bloat a useful product into mediocracy?! As a user of SQLce, my plea is this: please focus on enhancements to the core, like improving the collation support and optimizing the engine.

Thanks for your ear (eyes ;-),

-Nate

re: SQL Server Compact Edition under ASP.net and IIS

Steve.Lasker — Tue, 16 Jan 2007 20:12:11 GMT

Hi Roger,

Most of the sample code I've shown is either simple to reproduce, like the SqlCeResultset samples, or not something that can be actually done without the Sync Services runtime.

Now that SQLce 3.1 has shipped, and we're about to ship the public CTP of the Sync Services, it will be a little more realistic to post samples.

Steve

re: SQL Server Compact Edition under ASP.net and IIS

Steve.Lasker — Tue, 16 Jan 2007 20:46:10 GMT

Hi Nathan,

We will be expanding the reach of SQLce, but it will be with a focus in each area. We're still working out exactly how to achieve the specific goals. We will likely take advantage of the packaging model of SQLce. Meaning, the engine was designed to be modular. In some scenarios you may only want the storage engine, but not Merge Replication. Or if you're using the new Sync Services features, and don't need Merge, you can consume a subset of the dll's. For the caching scenarios, we may utilize SQLce under the covers, but not directly expose the engine. Not trying to set off any alarms here on black boxing things, just giving a view into how we might expand the features, yet still have focused scenarios.

As for sprocs, while it comes up regularly, we still do not plan to add them to the product. As outlined in the Comparing Express and SQLce whitepaper, and Anil's multiple comments on the subject, it just doesn't make sense to add them in our current and future scenario plans.

Steve

SQL Server精简版支不支持ASP.NET？

Bob Li — Tue, 06 Feb 2007 09:13:18 GMT

在我写了《在SQL Server Express版和Compact版之间做出选择》之后，园子里有些朋友问到SQL Server精简版(sqlce)支不支持ASP.NET？当时我也不确定，我自己测试过确实不行，但是觉得怪怪的，没有道理不支持啊！今天看了Steve Lasker的blog，终于搞清楚了！

re: SQL Server Compact Edition under ASP.net and IIS

David — Thu, 19 Apr 2007 16:39:57 GMT

The settings was change to SQLServerCompactEditionUnderWebHosting in RTM.

http://www.vidmar.net/weblog/archive/2007/04/19/SQL-Server-2005-Compact-Edition-and-ASP.NET.aspx

SQL Server CE - Great for prototyping and testing

joeyDotNet — Fri, 29 Jun 2007 21:57:58 GMT

SQL Server CE - Great for prototyping and testing

Demos, Presentations, Links, Screencasts and Videos for SQL Server Compact

Steve Lasker's Web Log — Wed, 26 Nov 2008 01:04:06 GMT

Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table