My application currently accesses SQL Server the "traditional" way - via EntityConnection on top of SqlClient. I would like to add the option of accessing SQL Server via a new OData service. Any ideas on the best way to do this? Is it possible to reuse the existing model-first EntityObject-derived classes? Thanks!
Client application that can access SQL Server via OData or directly via an Entity Framework SQL Connection
6.3k Views Asked by eug At
1
There are 1 best solutions below
Related Questions in ENTITY-FRAMEWORK
- Query (or LINQ in Entity Framework) for getting user's rank
- I'm trying to create a user with identity in .NET 8 with Entity Framework and I'm getting the following error, both in MySQL and SQL Server
- Entity Framework, Error when deleting data from multiple tables at the same time
- The instance of entity type 'User' cannot be tracked because another instance with the same key value for is already being tracked. Not structural
- Is it a good idea to use EF with Supabase?
- ModelState.IsValid is false when its Data Model Concurrency Token is non nullable
- EF6 Find function always go to the DB
- A second operation started on this context before a previous operation completed. in .NET Core
- Internal .NET Framework Data Provider error 1 in EF
- why cannot dotnet ef tools find my installed dotnet sdk and runtime
- Blazor hybrid cant add migration
- Access to all types, classes and interfaces from multiple projects through reflection in C#
- how to Store/Map Complex data type using EF?
- The database operation was expected to affect 1 row(s), on UpdateAsync
- Is it possible to generate database-agnostic migrations with Entity Framework?
Related Questions in ODATA
- How to serialize the entire Microsoft.AspNetCore.OData.Results.PageResult<T> object with Newtonsoft.Json in .NET 6?
- possible to index singleValueExtendedProperties in MsGraph?
- D365 F&O - Cannot post addresses with OData
- How to get access token correctly from SAP Successfactors api?
- Odata filter DateTime casting string to DateTime and Filtering
- Response payload is not odata payload
- how to remove namespace from query string to filter an enum field with OData V4 in .NET
- Odata Put endpoint doesn't work as expected on ASP.NET Core MVC web service
- Odata filter query Unrecognized 'Edm.String' literal 'datetime'
- OData unit testing in .NET Core 6.0
- OData rest API with MS Project Online (SharePoint) "User not found in active directory or Project db
- How to upload data in power apps table using python
- ASP.NET Core OData creating generic pass through controller for underlying APIs
- MS Graph /drives/{drive-id}/items/{item-id}/children filter not folders
- Connecting to URL with Token within SSIS
Related Questions in WCF-DATA-SERVICES
- Secure IIS-Hosted WCF-Service and use it in Xamarin.Forms
- The maximum message size quota for incoming messages (65536) has been exceeded (the all duplicates reviewed)
- What methods can be used to monitor or limit memory usage of a WCF service with multiple services running?
- Problem with getting data from a SQL table with foreign keys in a WCF project in Visual Studio
- WCF Rest Service Download File "Semaphore Exception"
- iis hosting WCF Service
- How does (configuration of) filtering work with WCF/EF/SQL Server views?
- WCF Unable to Parse SOAP Envelop, Only Getting Default Values
- The controller for path 'xxx' was not found or does not implement IController
- Dataservicecontext in WCF Service- insertion is slow savechanges()
- Getting 413 Payload too large then 500 System.ServiceModel.ServiceActivationException when i increase maxReceivedMessage in my WCF sharepoint app
- SharePoint wcf-services JSON DateTime format parsing in C#
- Email from HTML file with WCF Service
- How are SOAP web service namespaces customized
- How can I replace the $filter of a DataServiceQuery?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The best way would be to follow this tutorial to create an OData service: http://www.asp.net/web-api/overview/odata-support-in-aspnet-web-api/odata-v4/create-an-odata-v4-endpoint.
Update adding more details given the comment:
Although the link should be enough for answering the question, I can also elaborate on the end-to-end scenario a little bit.
Now the premium experience of creating an OData V4 service out of an SQL Server DB is to use the ASP.NET Web API 2.2 for OData V4. With the help of the code-first aspect of entity framework you can create an OData V4 service that supports pagination, queries, and CRUD operations in a very reasonable time (about 10 minutes for every table in your database).
As soon as the service is created, various client libraries that supports consuming V4 services can be at your service. The premium experience on the .NET platform is the OData v4 Client Code Generator.
If your consumer is a non-developer, Power Query can help you import the data from the OData service. Their support for V4 services will come early next year according to this, but Excel and Power Pivot already natively support consuming V1-3 services. For creating a V1-3 service, the tutorial next to the one I gave at first would help.