Category SQL

ASP.NET Core 3.0 MVC File Upload with MS SQL SERVER FileTable

This article shows how to upload and download files in ASP.NET Core 3.0 MVC and save the files to a MS SQL Server using FileTable. The data access for the application is implemented in a separate project and EF Core migrations is used to setup the select logic for the database. Code: https://github.com/damienbod/AspNetCoreFileUploadFileTable 2019-10-05: Updated […]

MVC CRUD with Elasticsearch child, parent documents

This article demonstrates how to search for data in Elasticsearch using parent and child documents. The documents are all saved inside the same index and the child documents are saved on the same shard using the parent id as the routing. As in the previous ElasticsearchCRUD tutorials, an autocomplete in used to search for the […]

Transferring data to Elasticsearch from MS SQL Server using ElasticsearchCRUD and Entity Framework

This article shows how to transfer data from a MS SQL Server 2014 to Elasticsearch. The MS SQL Server is accessed using Entity Framework (Code first from a database). Elasticsearch documents are created using ElasticsearchCRUD and inserted in bulk requests. The Entity Framework entities can be used directly in ElasticsearchCRUD. Either the whole entity including […]

Web API OData V4 Using a Singleton Part 7

This post is part 7 of the Web API and OData V4 series. This article demonstrates how to use an OData singleton with Web API. The singleton class has a list of child entities which is used to select contained entities from the SQLite database. Part 1 Getting started with Web API and OData V4 […]

Getting started with Web API and OData V4 Part 1

This article demonstrates how to create an OData V4 Web API service which uses Entity Framework 6 and SQL 2014 for persistence. OData V4 was released with Web API 2.2. The OData V4 standard is documented here: http://www.odata.org/documentation/. The Web API implementation does supports a lot of features from the standard, but not all. Part […]

Web API File Upload with MS SQL SERVER FileTable

This article demonstates how the setup a file upload using Web API and save it to a MS SQL Server database using a FileTable. Because a FileTable is used, the files can be saved directly to the database, without creating an extra stream. The files can be then accessed using the database or directly in […]

Getting started, using SQLite with .NET

This post is a collection from docs, links, code examples which I found on various blogs, websites etc. I have included the references to all my sources. Thanks for all the cool blogs, websites and of course SQLite which made it so easy to get started with this database. UPDATE 02.03.2014: With the release of […]