Category Entity Framework

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

December 5, 2015 · by · in .NET, ASP.NET Core, ASPNET5, dotnet, Entity Framework, MVC, SQL, Web · 38 Comments

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-12-21: Updated […]

OAuth2 Implicit Flow with AngularJS and ASP.NET Core 2.0 IdentityServer4

November 8, 2015 · by · in AngularJS, ASP.NET Core, ASPNET5, Entity Framework, MVC, OAuth2, Security, SQLite, TopHeaderMenu, Web · 45 Comments

This article shows how to implement the OAuth2 Implicit Flow with an AngularJS client and IdentityServer4 hosted in ASP.NET Core 1.1. The code was built using the IdentityServer4.Samples. Thanks to everyone who helped in creating IdentityServer. Code: https://github.com/damienbod/AspNet5IdentityServerAngularImplicitFlow History: 2017-08-15: Updated ASP.NET Core 2.0, Angular 4.3.6 Full history: https://github.com/damienbod/AspNet5IdentityServerAngularImplicitFlow#history Other posts in this series: OAuth2 […]

ASP.NET Core 2.0 with SQLite and Entity Framework Core

August 30, 2015 · by · in .NET, AngularJS, ASP.NET Core, ASPNET5, dotnet, Entity Framework, MVC, SQLite, TopHeaderMenu, Web · 15 Comments

This article shows how to use SQLite with ASP.NET Core 2.0 using Entity Framework Core. EF Core can now create SQLite databases using Entity Framework migrations which was not possible in previous versions. Code: https://github.com/damienbod/AspNetCoreSQLite 2017-08-17: Updated to ASP.NET Core 2.0 and EF Core 2.0 2017-02-02: Updated to VS2017 csproj with EF Core msbuild 2017-07-01: […]

MVC application with Entity Framework and Elasticsearch

November 2, 2014 · by · in .NET, Elasticsearch, Entity Framework, javascript, jQuery, Lucene, MVC, NoSQL, Web · 3 Comments

This article demonstrates how to use Entity Framework with MS SQL Server as a primary database and Elasticsearch for the search/select functionality. The application combines the power and performance of Elasticsearch for search and fast selects and also Entity Framework for CUD transactions (Create, Update and Delete). Code: https://github.com/damienbod/WebSearchWithElasticsearchEntityFrameworkAsPrimary Other tutorials: Part 1: ElasticsearchCRUD introduction […]

MVC CRUD with Elasticsearch child, parent documents

October 26, 2014 · by · in .NET, Elasticsearch, Entity Framework, Lucene, MVC, NoSQL, SQL, Web · Leave a comment

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

October 14, 2014 · by · in .NET, Elasticsearch, Entity Framework, Lucene, NoSQL, SQL · 1 Comment

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 Unity IoC, SQLite with EF6 and OData Model Aliasing Part 5

June 19, 2014 · by · in .NET, Entity Framework, OData, SQLite, TopHeaderMenu, Unity, Web · 1 Comment

This post is part 5 of the Web API and OData V4 series. This article shows how Web API 2.2 with OData V4 can be used together with Unity as an IoC, Entity Framework with SQLite for persistence and also creates an OData service which can do CRUD operations. OData Model Aliasing features are used […]

Getting started with Web API and OData V4 Part 1

June 10, 2014 · by · in .NET, Entity Framework, OData, SQL, TopHeaderMenu · 19 Comments

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

April 8, 2014 · by · in .NET, Entity Framework, MVC, SQL, TopHeaderMenu, UI, Unity, Web · 11 Comments

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 […]

using SQLite with Entity Framework 6 and the Repository Pattern

November 18, 2013 · by · in .NET, Entity Framework, SQLite, TopHeaderMenu, Unity · 11 Comments

In this post, a Data access layer is implemented using the repository pattern together with entity Framework 6 and SQLite as a database. The post continues on from Getting started, using SQLite with .NET UPDATE 02.03.2014: Using the new SQLite version 1.0.91.3 now with the SQLite provider. The xml app configuration needs to be changed […]

← Older posts Newer posts →