Everything SQL Server Compact

This blog tries to keep up with .NET Data Access related topics

  • Home
  • Contents
  • Tools
  • Forum
  • Twitter
  • Github

Monday, January 18, 2021

Advanced automated deployment of Azure SQL Database with Azure DevOps (part 2 of 4)

 Blog post here: Advanced automated deployment of Azure SQL Database with Azure DevOps (part 2 of 4) | ErikEJ's blog 

Indsendt af ErikEJ kl. 7:06 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, January 14, 2021

Advanced automated deployment of Azure SQL Database with Azure DevOps (part 1 of 4) - Add AAD administrator via ARM template

 Blog post here: Advanced automated deployment of Azure SQL Database with Azure DevOps (part 1 of 4) | ErikEJ's blog

Indsendt af ErikEJ kl. 2:03 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, January 5, 2021

Entity Framework Core 5 free resources

 Blog post here: Entity Framework Core 5 free resources | ErikEJ's blog 

Indsendt af ErikEJ kl. 3:14 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, November 2, 2020

Get a SQL Server stored procedure return value with EF Core

 Blog post here: https://erikej.github.io/efcore/2020/11/02/ef-core-sproc-return-value.html

Indsendt af ErikEJ kl. 3:36 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, October 27, 2020

Setting the command timeout with the latest .NET SqlClient

 Blog post here: https://erikej.github.io/sqlclient/2020/10/26/sqlclient-commandtimeout-preview.html

Indsendt af ErikEJ kl. 2:54 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, October 15, 2020

Entity Framework Core SQL Server reverse engineering a.k.a Database First gotchas (and workarounds)

 Blog post here: https://erikej.github.io/efcore/2020/10/12/ef-core-sqlserver-scaffolding-gotchas.html

Indsendt af ErikEJ kl. 8:10 AM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, September 23, 2020

Tips for making the most of EF Core with Azure SQL Database

 Blog post here: https://erikej.github.io/efcore/sqldb/2020/09/21/efcore-azure-sql-db.html 

Indsendt af ErikEJ kl. 3:19 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, September 7, 2020

EF Core Power Tools database reverse engineering: renaming of entities and properties

 Blog post here: https://erikej.github.io/efcore/2020/09/07/ef-core-power-tools-renaming-advanced.html

Indsendt af ErikEJ kl. 5:23 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, September 3, 2020

Creating, building and publishing Azure SQL Database projects on non-Windows platforms

 Blog post here: https://erikej.github.io/efcore/2020/08/31/ssdt-project-azure-datastudio.html

Indsendt af ErikEJ kl. 2:41 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, August 24, 2020

EF Core Power Tools reverse engineering advanced options

 Blog post here: https://erikej.github.io/efcore/2020/08/24/ef-core-power-tools-advanced-options.html

Indsendt af ErikEJ kl. 8:03 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Thursday, August 20, 2020

Using SQL Server Compact 4 with .NET Core 3.1 (on Windows only)

 Blog post here: https://erikej.github.io/sqlce/2020/08/17/netcore-sql-compact.html

Indsendt af ErikEJ kl. 6:25 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, August 10, 2020

Mapping and using SQL Server stored procedures with EF Core Power Tools

 Blog post here: https://erikej.github.io/efcore/2020/08/10/ef-core-power-tools-stored-procedures.html 

Indsendt af ErikEJ kl. 6:24 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Wednesday, August 5, 2020

Run migration scripts with sqlcmd and avoid issues with QUOTED_IDENTIFIER

Blog post here https://erikej.github.io/efcore/2020/08/04/ef-core-script-migrations-sqlcmd.html 
Indsendt af ErikEJ kl. 5:31 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, August 4, 2020

How to call stored procedures with OUTPUT parameters with FromSqlRaw in EF Core

Blog post at https://erikej.github.io/efcore/2020/08/03/ef-core-call-stored-procedures-out-parameters.html
Indsendt af ErikEJ kl. 4:55 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, June 22, 2020

Breaking changes in Microsoft.Data.SqlClient 2.0 (and potential mitigations)

Blog post here: https://erikej.github.io/sqlclient/efcore/2020/06/22/sqlclient-2-breaking-changes.html
Indsendt af ErikEJ kl. 9:25 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, June 15, 2020

Walk-through: Using an Entity Framework 6 EDMX file with .NET Core

Blog post here: https://erikej.github.io/ef/dotnetcore/2020/06/15/ef6-use-edmx-dotnetcore.html
Indsendt af ErikEJ kl. 5:11 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, June 8, 2020

Tips for .dacpac (SQL Server database project) deployment

Blog post here: https://erikej.github.io/efcore/2020/06/08/ssdt-dacpac-deploy.html
Indsendt af ErikEJ kl. 8:09 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Tuesday, May 26, 2020

Get a single, simple type value from a stored procedure with Entity Framework Core and raw SQL

Blog post here: https://erikej.github.io/efcore/2020/05/26/ef-core-fromsql-scalar.html
Indsendt af ErikEJ kl. 2:32 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, May 18, 2020

Simple logging with Entity Framework Core 5 and 'LogTo' (like Database.Log in EntityFramework 6)

Blog post here: https://erikej.github.io/efcore/2020/05/18/ef-core-simple-logging.html
Indsendt af ErikEJ kl. 8:18 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

Monday, May 11, 2020

Build (and publish) a .dacpac (SQL Server database project) with .NET Core - even on Linux or macOS!

blog post here: https://erikej.github.io/efcore/2020/05/11/ssdt-dacpac-netcore.html
Indsendt af ErikEJ kl. 5:43 PM No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)
Follow @ErikEJ

About Me

My photo
ErikEJ
Developer Technologies MVP, .NET and Data Access Developer, Contact: ejlskov(at)hotmail.com
View my complete profile

Blog Archive

  • ▼  2021 (3)
    • ▼  January 2021 (3)
      • Advanced automated deployment of Azure SQL Databas...
      • Advanced automated deployment of Azure SQL Databas...
      • Entity Framework Core 5 free resources
  • ►  2020 (24)
    • ►  November 2020 (1)
    • ►  October 2020 (2)
    • ►  September 2020 (3)
    • ►  August 2020 (5)
    • ►  June 2020 (3)
    • ►  May 2020 (4)
    • ►  April 2020 (4)
    • ►  March 2020 (2)
  • ►  2018 (1)
    • ►  March 2018 (1)
  • ►  2017 (1)
    • ►  January 2017 (1)
  • ►  2016 (4)
    • ►  December 2016 (1)
    • ►  August 2016 (1)
    • ►  February 2016 (1)
    • ►  January 2016 (1)
  • ►  2015 (11)
    • ►  August 2015 (1)
    • ►  July 2015 (2)
    • ►  April 2015 (2)
    • ►  March 2015 (5)
    • ►  January 2015 (1)
  • ►  2014 (22)
    • ►  December 2014 (2)
    • ►  October 2014 (2)
    • ►  September 2014 (1)
    • ►  August 2014 (1)
    • ►  June 2014 (3)
    • ►  May 2014 (2)
    • ►  April 2014 (3)
    • ►  March 2014 (3)
    • ►  February 2014 (2)
    • ►  January 2014 (3)
  • ►  2013 (38)
    • ►  December 2013 (2)
    • ►  November 2013 (3)
    • ►  October 2013 (2)
    • ►  September 2013 (3)
    • ►  August 2013 (1)
    • ►  July 2013 (1)
    • ►  June 2013 (4)
    • ►  May 2013 (3)
    • ►  April 2013 (3)
    • ►  March 2013 (5)
    • ►  February 2013 (6)
    • ►  January 2013 (5)
  • ►  2012 (28)
    • ►  December 2012 (1)
    • ►  November 2012 (2)
    • ►  October 2012 (1)
    • ►  August 2012 (4)
    • ►  July 2012 (1)
    • ►  June 2012 (1)
    • ►  May 2012 (3)
    • ►  April 2012 (3)
    • ►  March 2012 (3)
    • ►  February 2012 (3)
    • ►  January 2012 (6)
  • ►  2011 (38)
    • ►  December 2011 (2)
    • ►  November 2011 (4)
    • ►  October 2011 (2)
    • ►  September 2011 (5)
    • ►  August 2011 (3)
    • ►  July 2011 (2)
    • ►  June 2011 (3)
    • ►  May 2011 (4)
    • ►  April 2011 (2)
    • ►  March 2011 (4)
    • ►  February 2011 (3)
    • ►  January 2011 (4)
  • ►  2010 (53)
    • ►  December 2010 (2)
    • ►  November 2010 (4)
    • ►  October 2010 (3)
    • ►  September 2010 (4)
    • ►  August 2010 (6)
    • ►  July 2010 (5)
    • ►  June 2010 (4)
    • ►  May 2010 (6)
    • ►  April 2010 (6)
    • ►  March 2010 (5)
    • ►  February 2010 (2)
    • ►  January 2010 (6)
  • ►  2009 (51)
    • ►  November 2009 (2)
    • ►  October 2009 (4)
    • ►  September 2009 (3)
    • ►  August 2009 (7)
    • ►  July 2009 (2)
    • ►  June 2009 (6)
    • ►  May 2009 (5)
    • ►  April 2009 (5)
    • ►  March 2009 (3)
    • ►  February 2009 (6)
    • ►  January 2009 (8)
  • ►  2008 (36)
    • ►  December 2008 (1)
    • ►  November 2008 (2)
    • ►  October 2008 (2)
    • ►  September 2008 (3)
    • ►  August 2008 (6)
    • ►  June 2008 (2)
    • ►  May 2008 (1)
    • ►  April 2008 (4)
    • ►  March 2008 (4)
    • ►  February 2008 (4)
    • ►  January 2008 (7)
  • ►  2007 (8)
    • ►  November 2007 (3)
    • ►  October 2007 (1)
    • ►  August 2007 (4)

Popular Posts

  • Comparison of SQL Server Compact, SQLite, SQL Server Express and LocalDB
  • SQL Compact 3rd party tools
  • SQL Server Compact 4.0 released!
  • Using SQL Server Compact 4.0 with Desktop Private Deployment and a Setup project (MSI) (part 2)
  • Using SQLite with the Entity Framework 6.1.x designer - a troubleshooting guide
  • Visual Studio Tools for SQL Server Compact 4 now available
  • Migrating databases between SQL Server and SQL Server Compact
  • Entity Framework 6 & SQL Server Compact 4 (2)–Easy Private Desktop Deployment
  • SQLite Toolbox 4.0 – Visual Guide of Features
  • How to Migrate/Downsize a SQL Server database to SQL Server Compact 4.0 (and 3.5)

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

SQL Compact Technical Information

  • SQL Compact Product Group Blog
  • Steve Lasker's blog
  • SQL Compact KB articles
  • A Technical Comparison of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0
  • Background Data Synchronization with SQL Server 2005 Compact Edition
  • How to Develop an Efficient Architecture based on SQL Server CE Replication Requirements
  • Multi-User Considerations in Data Synchronization for SQL Server 2005 Mobile Edition 3.0
  • Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005
  • You Can Take It With You : SQL Server CE and Scalability
  • Upgrading from SQL Server CE 2.0 to SQL Server 2005 Compact Edition

Loading...
Powered by Blogger.