• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

Create API with .NET

Need help with architecture.  Currently have a SQL Server database that contains 1++ Million records. I need to develop an API which will allow customers to connect to it and obtain the data that they need.  

Can anyone provide sample solutions to provide this capability?

Is remoting an option?  Is remoting going away?
0
CipherIS
Asked:
CipherIS
  • 3
  • 2
1 Solution
 
tlaytonCommented:
Are your customers developers then? You could write a series of Web Services that get data from the database but be careful to limit the amount of data being sent from any single request - do this using parameters and subsets of the data if the query is not specific enough...
0
 
CodeCruiserCommented:
I would rather provide services given that SOA is so popular. Now whether to use webservices or WCF services will depend on your clients as webservices can be executed by different types of clients over HTTP.
0
 
CipherISAuthor Commented:
how would you access the data for 1+ Million records for a web service?  ADO or Entity?  Can Entity be used with Web Service?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
tlaytonCommented:
I would use ADO to Stored Procedures personally, given that you want good performance and the data set is fairly large, in my experience it outperforms Entity with large sets of data...
0
 
tlaytonCommented:
No, it actually specifically mentions SPs outperform EF as I mentioned ;-)
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now