ASP.Net Core - Using SQLite - Data showing, but not saving with Entity Framework

asp.net asp.net-core entity-framework entity-framework-core sqlite

Question

I am trying to use SQLite in ASP.Net Core with EntityFramework Core.

When I am in debug mode (With Visual Studio), everything is working fine.

When I publish it, and I am trying to receive data, it is working.

Data read controller is like this-

[HttpGet]
public async Task<IActionResult> Get(int start=0,int end=0)
{
    var bulletins = await _context.Bulletin
        .Include(u => u.Descriptions)
        .Include(u => u.Images)
        .ToArrayAsync();

    var response = bulletins.Select(u => new
    {
        Id = u.Id,
        UserId = u.UserId,
        Title = u.Title,
        Descriptions = u.Descriptions.Select(p => p.Text),
        Images = u.Images.Select(p => p.Name),
        BaseUrl = "localhost/uploads/"
    });

    return Ok(response);
}

But when I am trying to save data like this-

[HttpPost]
public IActionResult Insert(BulletinViewModel data, ICollection<IFormFile> image)
{
    List<Description> bulletinDescription = new List<Description>();

    foreach (var description in data.text)
    {
        bulletinDescription.Add(new Description{ Text = description });
    }

    //string filename1 = _environment.WebRootPath;

    List<Image> bulletinImages = new List<Image>();
    string path = Directory.GetCurrentDirectory();

    foreach (var file in image)
    {
        string fileName = Path.GetFileNameWithoutExtension(file.FileName);
        string extention = Path.GetExtension(file.FileName);

        var filename = ( data.user_id
                        + "_"
                        + Guid.NewGuid().ToString()
                        + "_"
                        + fileName
                        +extention).Trim('"');

        bulletinImages.Add(new Image { Name = filename });

        var serverFile = uploadDirectory + $@"/{filename}";
        //file.Length;
        using (FileStream fileStream = System.IO.File.Create(serverFile))
        {
            file.CopyTo(fileStream);
            fileStream.Flush();
        }
    }

    Bulletin bulletin = new Bulletin {
        UserId = data.user_id,
        Title = data.title,
        Descriptions = bulletinDescription,
        Images = bulletinImages
    };

    _context.Bulletin.Add(bulletin);
    _context.SaveChanges();

    return Ok(bulletin);
}

It is not working in production (after published) while it is working in debug mode (with visual studio).

I am geting this errors (Total log is given here)-

   Hosting environment: Production
   Content root path: D:\Publish
   Now listening on: http://localhost:5000
   Application started. Press Ctrl+C to shut down.
   info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
         Request starting HTTP/1.1 GET http://localhost:5000/api/bulletin/get
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (3ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         SELECT COUNT(*) FROM "sqlite_master" WHERE "type" = 'table' AND "rootpage" IS NOT NULL;
   info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
         Executing action method BugTracker.api.BulletinController.Get (BugTracker) with arguments (0, 0) - ModelState is Valid
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         SELECT "u"."Id", "u"."Title", "u"."UserId"
         FROM "Bulletin" AS "u"
         ORDER BY "u"."Id"
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         SELECT "i"."Id", "i"."BulletinId", "i"."Name"
         FROM "Image" AS "i"
         WHERE EXISTS (
             SELECT 1
             FROM "Bulletin" AS "u"
             WHERE "i"."BulletinId" = "u"."Id")
         ORDER BY "i"."BulletinId"
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         SELECT "d"."Id", "d"."BulletinId", "d"."Text"
         FROM "Description" AS "d"
         WHERE EXISTS (
             SELECT 1
             FROM "Bulletin" AS "u"
             WHERE "d"."BulletinId" = "u"."Id")
         ORDER BY "d"."BulletinId"
   info: Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor[1]
         Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
   info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
         Executed action BugTracker.api.BulletinController.Get (BugTracker) in 4224.5672ms
   info: Microsoft.AspNetCore.Hosting.Internal.WebHost[2]
         Request finished in 5902.4455ms 200 application/json; charset=utf-8
   info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
         Request starting HTTP/1.1 POST http://localhost:5000/api/bulletin/insert multipart/form-data; boundary=----WebKitFormBoundaryGALOJJbtKdvvVFah 2532310
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         SELECT COUNT(*) FROM "sqlite_master" WHERE "type" = 'table' AND "rootpage" IS NOT NULL;
   info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
         Executing action method BugTracker.api.BulletinController.Insert (BugTracker) with arguments (BugTracker.Model.ViewModels.BulletinViewModel, System.Collections.Generic.List`1[Microsoft.AspNetCore.Http.IFormFile]) - ModelState is Valid
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
         PRAGMA foreign_keys=ON;
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (4ms) [Parameters=[@p0='?', @p1='?'], CommandType='Text', CommandTimeout='30']
         INSERT INTO "Bulletin" ("Title", "UserId")
         VALUES (@p0, @p1);
         SELECT "Id"
         FROM "Bulletin"
         WHERE changes() = 1 AND "Id" = last_insert_rowid();
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[@p2='?', @p3='?'], CommandType='Text', CommandTimeout='30']
         INSERT INTO "Description" ("BulletinId", "Text")
         VALUES (@p2, @p3);
         SELECT "Id"
         FROM "Description"
         WHERE changes() = 1 AND "Id" = last_insert_rowid();
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[@p0='?', @p1='?'], CommandType='Text', CommandTimeout='30']
         INSERT INTO "Description" ("BulletinId", "Text")
         VALUES (@p0, @p1);
         SELECT "Id"
         FROM "Description"
         WHERE changes() = 1 AND "Id" = last_insert_rowid();
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[@p0='?', @p1='?'], CommandType='Text', CommandTimeout='30']
         INSERT INTO "Image" ("BulletinId", "Name")
         VALUES (@p0, @p1);
         SELECT "Id"
         FROM "Image"
         WHERE changes() = 1 AND "Id" = last_insert_rowid();
   info: Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommandBuilderFactory[1]
         Executed DbCommand (0ms) [Parameters=[@p0='?', @p1='?'], CommandType='Text', CommandTimeout='30']
         INSERT INTO "Image" ("BulletinId", "Name")
         VALUES (@p0, @p1);
         SELECT "Id"
         FROM "Image"
         WHERE changes() = 1 AND "Id" = last_insert_rowid();
   info: Microsoft.AspNetCore.Mvc.Internal.ObjectResultExecutor[1]
         Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext.
   fail: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[0]
         An unhandled exception has occurred: Self referencing loop detected for property 'bulletin' with type 'BugTracker.DbModels.Mcp.Bulletin'. Path 'descriptions[0]'.
   Newtonsoft.Json.JsonSerializationException: Self referencing loop detected for property 'bulletin' with type 'BugTracker.DbModels.Mcp.Bulletin'. Path 'descriptions[0]'.
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.CheckForCircularReference(JsonWriter writer, Object value, JsonProperty property, JsonContract contract, JsonContainerContract containerContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.CalculatePropertyValues(JsonWriter writer, Object value, JsonContainerContract contract, JsonProperty member, JsonProperty property, JsonContract& memberContract, Object& memberValue)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)
      at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)
      at Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter.WriteObject(TextWriter writer, Object value)
      at Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter.<WriteResponseBodyAsync>d__9.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultAsync>d__32.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultFilterAsync>d__31.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAllResultFiltersAsync>d__29.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResourceFilterAsync>d__23.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAsync>d__18.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.ApplicationInsights.AspNetCore.ExceptionTrackingMiddleware.<Invoke>d__4.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>d__6.MoveNext()
   warn: Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware[0]
         The response has already started, the error handler will not be executed.
   fail: Microsoft.AspNetCore.Server.Kestrel[13]
         Connection id "0HKUCLKEV7G2Q": An unhandled exception was thrown by the application.
   Newtonsoft.Json.JsonSerializationException: Self referencing loop detected for property 'bulletin' with type 'BugTracker.DbModels.Mcp.Bulletin'. Path 'descriptions[0]'.
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.CheckForCircularReference(JsonWriter writer, Object value, JsonProperty property, JsonContract contract, JsonContainerContract containerContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.CalculatePropertyValues(JsonWriter writer, Object value, JsonContainerContract contract, JsonProperty member, JsonProperty property, JsonContract& memberContract, Object& memberValue)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeList(JsonWriter writer, IEnumerable values, JsonArrayContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.SerializeObject(JsonWriter writer, Object value, JsonObjectContract contract, JsonProperty member, JsonContainerContract collectionContract, JsonProperty containerProperty)
      at Newtonsoft.Json.Serialization.JsonSerializerInternalWriter.Serialize(JsonWriter jsonWriter, Object value, Type objectType)
      at Newtonsoft.Json.JsonSerializer.SerializeInternal(JsonWriter jsonWriter, Object value, Type objectType)
      at Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter.WriteObject(TextWriter writer, Object value)
      at Microsoft.AspNetCore.Mvc.Formatters.JsonOutputFormatter.<WriteResponseBodyAsync>d__9.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultAsync>d__32.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResultFilterAsync>d__31.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAllResultFiltersAsync>d__29.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeResourceFilterAsync>d__23.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeAsync>d__18.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Builder.RouterMiddleware.<Invoke>d__4.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.ApplicationInsights.AspNetCore.ExceptionTrackingMiddleware.<Invoke>d__4.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>d__6.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.<Invoke>d__6.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.ApplicationInsights.AspNetCore.RequestTrackingMiddleware.<Invoke>d__4.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Builder.Extensions.MapMiddleware.<Invoke>d__3.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Hosting.Internal.RequestServicesContainerMiddleware.<Invoke>d__3.MoveNext()
   --- End of stack trace from previous location where exception was thrown ---
      at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
      at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
      at Microsoft.AspNetCore.Server.Kestrel.Internal.Http.Frame`1.<RequestProcessingAsync>d__2.MoveNext()
   info: Microsoft.AspNetCore.Hosting.Internal.WebHost[2]
         Request finished in 12477.1332ms 200 application/json; charset=utf-8

Can anyone please help?

Thanks in advance for helping.

1
0
8/25/2016 6:05:44 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Thanks Adem Caglin for referance.

I have done this-

services.AddMvc().AddJsonOptions(options => {
        options.SerializerSettings.ReferenceLoopHandling =  ReferenceLoopHandling.Ignore;
    });

And everything is OK :).

More can be found here and here.

0
5/23/2017 12:15:00 PM

Related Questions

Entity framework Core with Identity and ASP.NET Core RC2 not creating user in database

I am working on an application with authentication. I am using the following frameworks:...ASP.NET Core RC2...Entity Framework Core...The Npgsql EFCore driver...For seeding I created a ...DataSeeder... class, that gets added as Transient Service in the ...ConfigureServices... function and later called in the Configure function. It checks whether a...
asp.net-core entity-framework-core
asked by larzz11

Entity Framework Core with SQLite: ASP.NET application holding onto database in memory

Thanks in advance for your help. ...I'm using my Mac to develop and ASP.NET Core application with SQLite as the database (when learning about SQLite and EF Core, I read through this tutorial: ...https://docs.microsoft.com/en-us/ef/core/get-started/netcore/new-db-sqlite...). Migrations and updating the database schema are working, but it seems as th...
asp.net-core c# entity-framework-core sqlite
asked by Dan

Using Data Annotations for SQLite in Entity Framework Core

I am using the Entity Framework Core to interface my SQLite database. I want to set a minimum and maximum range for the field ...ExitSide... in my model ...Station...:...using System.ComponentModel.DataAnnotations; ... class Station { public int StationId { get; set; } [Range(0,2)] public int ExitSide { get; set; } } ...But somehow it s...
c# entity-framework-core sqlite
asked by arminb

ASP.NET Core 2.1 Entity Framework Core Related Data Duplication

I'm trying to build an ASP.NET Core API which returns an object containing some of related, joined, data....But when I call an Article model using Include(), it's mapped automatically by EF Core. Which is intended, but.. unexpected mapping is occurring....EF Core produce fully mapped object for all objects so that too much data is generated....For ...
asp.net-core-2.0 asp.net-core-2.1 asp.net-core-webapi entity-framework-core
asked by Jason Kim

Where is the Sqlite database saved for asp.net core MVC 2.2?

I create an asp.net core mvc 2.2 application with ...options.UseSqlite("Data Source=test.db") ...Important note: VS2017 must be launched with Administrative Privilege, otherwise database cannot be created. It is specific to Asp.net core 2.2, the previous one has no such a problem....Question...Where is the sqlite database saved? I have searched for...
asp.net-core asp.net-core-2.2 entity-framework-core
asked by Only The Paranoid Survive

Data Encryption in Data Layer with ASP.NET Core Entity Framework

I am currently designing a web application where the data needs to be stored encrypted....Planned technologies used:...ASP.NET Core API ASP.NET Core Entity Framework MS SQL Server 2012 any Web Frontend Because of the specification, we need to store all data encrypted in the database....Which would be a good approach to achieve this while still be a...
.net asp.net-core c# entity-framework-core
asked by Amol Vasaikar

How to install entity framework core to asp.net core 3 project using visual studio code

I'm creating a new MVC application using visual studio code and I want to add entity framework core to my project. My application is using the latest .net core 3 but when I tried to install package ...Microsoft.EntityFrameworkCore.SqlServer... its show an error like this ...Unable to resolve 'Microsoft.EntityFrameworkCore.SqlServer (>= 3.0.0)' for ...
asp.net-core c# entity-framework-core visual-studio-code
asked by codeken

Loading related data in Entity Framework Core and ASP.NET Core

Your ShoeImages filed corresponds to multiple ImageURL fields because it is of type ICollection....You can use the following view code to show them....@model IEnumerable<Shoes.Data.Entities.ShoeEntity> <p> <a asp-action="Create">Create New</a> </p> <table class="table"> <thead> <tr> <th> @Html.Displa...
asp.net asp.net-core asp.net-mvc c# entity-framework-core
asked by Yongqing Yu

ASP.NET Core + Entity Framework Core + SQLite Creating initial migration throws error

I am doing a ASP.NET Core beginner tutorial on Udemy. The task is to create a Code First SQLite database and I want to create a Initial migration which is failing. Below I describe the steps I have made....I have installed the packages ...Microsoft.EntityFrameworkCore Microsoft.EntityFrameworkCore.Design Microsoft.EntityFrameworkCore.SQLite ...The ...
asp.net-core ef-migrations entity-framework-core sqlite
asked by canvee

Unable to send array data using ajax with ASP.NET Core and Entity Framework Core

you are sending a string with no names so the controller can not get the values....change you code to...$.ajax({ type:"POST", url:url, data:test ... }); ...the ...test... should be an ...object... not a ...string....
asp.net-core asp.net-core-2.0 asp.net-mvc entity-framework-core
asked by liang.good

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow