How to retrieve image from database(SQL Server) in angular using LINQ?

Question

The image is saved in DB using particular ID. Now I need to display the image when that ID is selected. This has to be done in Angular using LINQ . Any examples for this case?

Sachin Singh · Answer

Angular and Linq has no direct relation. Angular is a client-side framework, while LINQ is the technology that enables you to query any data source without having the knowledge of their internal architecture. This means-, you can query SQL server database or XML files, or in-memory collections all with a uniform Linq syntax, without learning SQL or XPath, or Generics respectively. Coming to your question, you need to create one API, better, create an API using ASP.NET Core WEB API or ASP.NET API (.NET Framework). Inside the controller, use Entity Framework DbContext, DbSet, and Query DbSets using Linq where DbSets are nothing but In-Memory collections of your database tables. On the client-side, Angular provides HttpClient to issue HTTP requests. Example (API exposing employee data) [Get employee having id=1 (POST request)] ngOnInit() { this .http.post ( 'localhost://1234/API/Employee' , { Id:1 }).subscribe({ next: data => { this .Name= data.Name, this .Gender=data.Gender. ; }, error: error => { this .errorMessage = error.message; console.error( 'There was an error!' , error); } }) }

Muhammad Imran Ansari · Answer

Check this nice post on this: https://www.aspsnippets.com/questions/954336/Display-Binary-Image-from-database-using-AngularJS-and-Web-Service-in-ASPNet/

How to retrieve image from database(SQL Server) in angular using LINQ?

Answers (2)