dotnet falcon (Page 10)

Entity Framework Logical Delete Part One: Intro and Questions

Jul 17, 2017

I've been planning to write a blog post about how to achieve the so called "logical delete" or "soft delete" when using Entity Framework. This is the kind of requirement you have when you are not allowed to physically delete records from your database

LinqPad DocumentDb (now CosmosDb) driver

Akos Nagy

May 22, 2017

If you are a .NET programmer, you are probably familiar with LinqPad. I myself find it useful in some situations (and there are others, when not) and I do use it myself. For a while I've been looking for a new project that I could hack on in

StackOverflow Adventures: Add custom info to Web API help page

Akos Nagy

May 1, 2017

I like stackoverflow. It provides me a way to keep in touch with the community, meet other schools of thought and test my knowledge on occasion. I like the interesting problems and questions. Take this one for example: http://stackoverflow.com/questions/42691154/provide-documentation-for-asp-net-web-api-method-with-a-dynamic-query-string The question goes like this: I&

StackOverflow Adventures: DocumentDb and inheritance

Akos Nagy

Mar 27, 2017

I stumbled upon this question on StackOverflow: http://stackoverflow.com/questions/42858166/deserialize-json-into-multiple-inherited-classes/42858968#42858968 Here's the gist of it: OP wanted to store instances of different descendants of a class in DocumentDb and then read them back — but it wasn't working. So what's

Stealing time in SQL Server

Akos Nagy

Mar 20, 2017

Here's a question for you: what is the output of this simple script in T-SQL if I run it on SQL Server 2016 Developer Edition (or any other edition and any other version, for that matter): declare @t1 datetime='2017-03-20 12:46:37.000'; declare @t2

SQL Server

StackOverflow Adventures: DocumentDb response chunking

Akos Nagy

Mar 17, 2017

Not long ago I stumbled upon this interesting question on stackoverflow: http://stackoverflow.com/questions/42600008/how-to-get-more-than-100-query-results-with-azure-documentdb-rest-api The asker used the REST API of Azure DocumentDb to query some data, but they could only get back the first 100 documents. If they used the .NET SDK, they could get all

Entity Framework Code First: Relationship mapping

Akos Nagy

Mar 11, 2017

I guess there's really no point in stating again how much I think EF CF is awesome (just check this post or this post). There's a lot of magic in EF CF — and of course there are more straightforward things. Mapping entities is one of the

StackOverflow adventures: Entity Framework Code First advanced mapping scenarios

Akos Nagy

Mar 5, 2017

A couple of days back I was lucky enough to answer this question on stackoverflow: http://stackoverflow.com/questions/42532083/how-to-map-a-property-to-a-different-table-using-entity-framework So basically the question was about how to split an entity into two tables. And this let me to writing this blog post on advanced mapping scenarios. When you

.NET Workbooks: 101 Linq samples

Akos Nagy

Mar 1, 2017

Just yesterday I did a post on something called Xamarin Workbooks. In the post I elaborate on how cool this is and how useful I think this tool will be during my classes. Ever since a thread in my brain-process has been working on finding cool new ideas to present

.NET
C#

.NET Workbooks: Entity Framework Model Explorer

Akos Nagy

Feb 28, 2017

I've been a long time follower of Scott Hanselman. I mean, who hasn't? The guy has a very good sense of technology and has some great insights about .NET stuff, but beyond that, he has a special attitude towards life in general (as far as I