Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
jadhav_vilas84
Advocate II
Advocate II

how to create odata service using sql server for big size data using .net

Hi, 

 

Please help for creating Odata service using .net and sql server , in my sql tables contain 24, 00,000 records ,

 

Please help for this.

 

thanks

vilas jadhav

jadhav_vilas84@yahoo.com 

 

2 REPLIES 2
Sergeik
New Member

Hi,

 

Why don't you want simply to use a 3rd party solution, like Skyvia Connect, to expose your SQL Server data as OData REST API, and use it in real time? Skyvia has OData connectors for cloud applications and relational databases, including SQL Server.

Greg_Deckler
Community Champion
Community Champion

Not entirely sure this is the correct community for that, you would probably have more luck on a TechNet developer forum, but here is a link to get you started:

 

http://www.asp.net/web-api/overview/odata-support-in-aspnet-web-api

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.