Asp.Net API C# To Query SQL Server

Can someone fix my C# syntax to query SQL Server from ASP.Net?

This is my syntax I attempt but I have multiple compile errors -> what would be the proper way to do this?

public class InvoicePullController : ApiController


public IEnumerable<Invoice> Get()


List<Invoice> result = new List<Invoice>();

using (XamarinEntities entities = new XamarinEntities())


result = (from cm in [login to view URL]

join inv [login to view URL] on [login to view URL] equals [login to view URL]

orderby [login to view URL]

select new


[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL],

[login to view URL]



return result;



public class Invoice


public string company { get; set; }

public int invoicenum { get; set; }

public string invoiceamt { get; set; }

public DateTime invoiceduedate { get; set; }

public DateTime invoicepaiddate { get; set; }


Habilidades: .NET, ASP.NET, Programação C#

Veja mais: parent child query sql server, uusing data adaptor aspnet query sql server database, net 2008 project active directory sql server, web api database connection, asp.net web api with database, asp.net web api sql database, web api get data from database, retrieve data from database in web api c#, rest api c# sql server, web api sql server, connect web api to sql server database c#, arcgis vba query sql server, excel web query sql server, access vab query sql server, asp net api reflection dll testing tool, asp net api send sms web, asp net web service data insert sql server, asynchronous asp net api, browse images google site asp net api, bulk sms asp net api

Acerca do Empregador:
( 0 comentários ) Athens, United States

ID do Projeto: #18281016

17 freelancers estão ofertando em média $29 para esse trabalho


Hello sir/madam. I can correct your code to work properly. Please share entire solution folder and I will do it fast. Regards

$35 USD em 1 dia
(119 Comentários)

Hi I'm c# developer with 12 years experience on .net framework and related tools, I'll fix your code with teamviewer, please send me a message to have discussion about details and fix an online session.

$45 USD em 1 dia
(31 Comentários)

Hi, I'm .NET Developer Available for Immediate Start Contact me for Quality Work. Relevant Skills I have: ASP.NET / MVC / Linq / .NET Core / SQL HTML/CSS/Bootstrap, JS/Jquery, Git, TFS Thank you Mais

$30 USD em 1 dia
(23 Comentários)

Hi Plz try to replace this, if you feel it is resolve or need any help let talk further. select new { company = [login to view URL], invoicenum = [login to view URL], invoiceamt = [login to view URL], invoicedate = [login to view URL] Mais

$30 USD em 1 dia
(27 Comentários)

Hello, Please give me chance to discuss the project details over chat. I am MS full stack developer having expertise in developing web, desktop and mobile applications using MS stack and I am offering my services Mais

$25 USD em 1 dia
(17 Comentários)

Hi , i can write sql query for you . Message me i can start now . Thanks ............................

$30 USD em 1 dia
(21 Comentários)

i can do this sir give me a chance to serve u ...........................................................................................................................................

$20 USD em 1 dia
(14 Comentários)

Hello, Can you please share the errors and your current code? The errors may be due to for a lot of reasons. Thanks.

$25 USD em 1 dia
(3 Comentários)

hello what kind of errors you get can i see compile error list what errors you got during compilation ?

$25 USD em 1 dia
(11 Comentários)

Hello, I would like to take this assignment. I am having 14 years of experience on web development, deployment and project management. Below are my core technical skills •ASP.Net /HTML/CSS/JavaScript/JQuery •C# Mais

$25 USD em 1 dia
(4 Comentários)

Hello, I can fix your C# web api code to query your database. Are you using Entity Framework? Can you send me your visual studio Project? Regards Alfred

$25 USD in 2 dias
(4 Comentários)

Hi. Did you solved that already? Looks like you trying to return anonymous class instead of Invoice, you need instantiate it as new Invoice

$35 USD em 1 dia
(5 Comentários)

hi, please let me know do you code in xamarin ?? i hv knowledge in c# so i can solve the issue. pong me on chat so i can fix the issue.

$25 USD em 1 dia
(1 Comentário)

Hi there. I've just read your proposal carefully. I can complete your task on time. I want to catch your syntax error, but I don't know your database. contact me. I will help you.

$25 USD em 1 dia
(0 Comentários)

I have 3 years of experience in asp.net, c#, SQL server, html, jQuery, JavaScript, html, c#, css. I worked related project.

$13 USD in 20 dias
(0 Comentários)
$25 USD em 1 dia
(0 Comentários)

HI, I noticed that you are looking for a Expert to work on your Project,I have gone through your requirement and would like to take this opportunity to provide you best solution for the same. With having more th Mais

$55 USD em 1 dia
(0 Comentários)