Over time I wrote some posts relating to SQLCE as a nice standalone Database platform that can by used in PowerShell or Webmatrix on IIS etc.
Now that MS has announced the end of life of Webmatrix …
“WebMatrix product support ends on November 1st, 2017”
As Webmatrix runs on MSSQLCE we need to look for alternatives…
“MS SQLCE support will end in July 2021”
One of the most obvious alternative is of course SQLite, which is shipped as part of AutoIT
Besides this, SQLite has much more to offer then SQLCE :
As you can see the size limit is 140 TB and unlimited concurrent users !
And it runs on Windows / Linux / Mac … and as well on Mobile devices.
So this will do for a while …
1. Download the appropriate .NET Assembly for your environment
2. Run this PS code :
Add-Type -Path "C:\Temp\.NET SQLite Library\System.Data.SQLite.dll" $con = New-Object -TypeName System.Data.SQLite.SQLiteConnection $con.ConnectionString = "Data Source=C:\Temp\.NET SQLite Library\northwindEF.db" $con.Open() $sql = $con.CreateCommand() $sql.CommandText = "SELECT * FROM Customers" $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql $data = New-Object System.Data.DataSet [void]$adapter.Fill($data) "Rows # : " + $data.tables.rows.count $data.tables.rows | Out-GridView # | ft
3. Test it.
Once you run it you can access the SQLite Database lightning fast …
Some more Tips and Tools you can find here :