Everything SQL Server Compact View RSS

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



Advanced automated deployment of Azure SQL Database with Azure DevOps (part 2 of 4) 18 Jan 2021 9:06 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Advanced automated deployment of Azure SQL Database with Azure DevOps (part 1 of 4) - Add AAD administrator via ARM template 14 Jan 2021 4:03 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Entity Framework Core 5 free resources 5 Jan 2021 5:14 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Get a SQL Server stored procedure return value with EF Core 2 Nov 2020 5:36 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Setting the command timeout with the latest .NET SqlClient 27 Oct 2020 5:54 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Entity Framework Core SQL Server reverse engineering a.k.a Database First gotchas (and workarounds) 14 Oct 2020 10:10 PM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Tips for making the most of EF Core with Azure SQL Database 23 Sep 2020 5:19 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

EF Core Power Tools database reverse engineering: renaming of entities and properties 7 Sep 2020 7:23 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Creating, building and publishing Azure SQL Database projects on non-Windows platforms 3 Sep 2020 4:41 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

EF Core Power Tools reverse engineering advanced options 24 Aug 2020 10:03 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Using SQL Server Compact 4 with .NET Core 3.1 (on Windows only) 20 Aug 2020 8:25 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Mapping and using SQL Server stored procedures with EF Core Power Tools 20 Aug 2020 8:25 AM (4 years ago)

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

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Run migration scripts with sqlcmd and avoid issues with QUOTED_IDENTIFIER 5 Aug 2020 7:31 AM (4 years ago)

Blog post here https://erikej.github.io/efcore/2020/08/04/ef-core-script-migrations-sqlcmd.html 

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

How to call stored procedures with OUTPUT parameters with FromSqlRaw in EF Core 4 Aug 2020 6:55 AM (4 years ago)

Blog post at https://erikej.github.io/efcore/2020/08/03/ef-core-call-stored-procedures-out-parameters.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Breaking changes in Microsoft.Data.SqlClient 2.0 (and potential mitigations) 22 Jun 2020 11:25 AM (4 years ago)

Blog post here: https://erikej.github.io/sqlclient/efcore/2020/06/22/sqlclient-2-breaking-changes.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Walk-through: Using an Entity Framework 6 EDMX file with .NET Core 15 Jun 2020 7:11 AM (4 years ago)

Blog post here: https://erikej.github.io/ef/dotnetcore/2020/06/15/ef6-use-edmx-dotnetcore.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Tips for .dacpac (SQL Server database project) deployment 8 Jun 2020 10:09 AM (4 years ago)

Blog post here: https://erikej.github.io/efcore/2020/06/08/ssdt-dacpac-deploy.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Get a single, simple type value from a stored procedure with Entity Framework Core and raw SQL 26 May 2020 4:32 AM (4 years ago)

Blog post here: https://erikej.github.io/efcore/2020/05/26/ef-core-fromsql-scalar.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Simple logging with Entity Framework Core 5 and 'LogTo' (like Database.Log in EntityFramework 6) 18 May 2020 10:18 AM (4 years ago)

Blog post here: https://erikej.github.io/efcore/2020/05/18/ef-core-simple-logging.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Build (and publish) a .dacpac (SQL Server database project) with .NET Core - even on Linux or macOS! 11 May 2020 7:43 AM (4 years ago)

blog post here: https://erikej.github.io/efcore/2020/05/11/ssdt-dacpac-netcore.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

New features in Microsoft.Data.SqlClient 2.0 preview 3 4 May 2020 7:40 AM (4 years ago)

Blog post here: https://erikej.github.io/sqlclient/2020/05/04/mds-version2-preview3.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Pluralization with EF Core and EF Core Power Tools 27 Apr 2020 7:02 AM (5 years ago)

Blog post here: https://erikej.github.io/efcore/2020/04/26/ef-core-pluralization.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

How to pass a dynamic/variable list of values as SqlParameters with FromSqlRaw in EF Core 20 Apr 2020 7:32 AM (5 years ago)

New blog post: How to pass a dynamic/variable list of values as SqlParameters with FromSqlRaw in EF Core

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Generate Entity Framework Core classes from a SQL Server database project - .dacpac file 19 Apr 2020 1:23 AM (5 years ago)

New blog post: Generate Entity Framework Core classes from a SQL Server database project - .dacpac file

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?

Query non-table classes using ad-hoc (raw) SQL with EF Core 3.1 6 Apr 2020 7:25 AM (5 years ago)

Blog post here: https://erikej.github.io/efcore/2020/04/06/query-non-table-classes-raw-sql.html

Add post to Blinklist Add post to Blogmarks Add post to del.icio.us Digg this! Add post to My Web 2.0 Add post to Newsvine Add post to Reddit Add post to Simpy Who's linking to this post?