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

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);
}
})
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted 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 Ansari4y ago
Check this nice post on this:
https://www.aspsnippets.com/questions/954336/Display-Binary-Image-from-database-using-AngularJS-and-Web-Service-in-ASPNet/