EF 6 and C# applications (Web & Windows)
-
Hi, We know First time EF loads metadata into memory, that takes a time and it will be faster in the seconed time because the EF metadata was loaded in the memory, my question is: In the Web Application (MVC or Classic Web Application) is the EF must loaded every request or it is loaded at the first time. Please let me know the Best way to get the Best Performance of the EF. Please let me know what is your recommended technology to use in our system (MVC with EF), (Web Application with ADO.Net),... We need to use a technology with the following criteria: 1- Portability: Run across different platforms 2- Mobility: Mobile application 3- Scalability: Capability to handle growing of work amount (Small, medium, and large business or data). 4- Security: Protect against malicious attack and other hacker risks 5- Cloud 6- Licensing: License price to use the technology 7- Performance 8- DB independence: Could be used with any Database (MS SQL, Oracle, MySQL) 9-Maintainability: The degree to which an application is understood, repaired, or enhanced. 10-Product type: desktop, web, mobile. 11-Also what is your recommended 3td party tools such as DevExpress,...etc Thank You
-
Hi, We know First time EF loads metadata into memory, that takes a time and it will be faster in the seconed time because the EF metadata was loaded in the memory, my question is: In the Web Application (MVC or Classic Web Application) is the EF must loaded every request or it is loaded at the first time. Please let me know the Best way to get the Best Performance of the EF. Please let me know what is your recommended technology to use in our system (MVC with EF), (Web Application with ADO.Net),... We need to use a technology with the following criteria: 1- Portability: Run across different platforms 2- Mobility: Mobile application 3- Scalability: Capability to handle growing of work amount (Small, medium, and large business or data). 4- Security: Protect against malicious attack and other hacker risks 5- Cloud 6- Licensing: License price to use the technology 7- Performance 8- DB independence: Could be used with any Database (MS SQL, Oracle, MySQL) 9-Maintainability: The degree to which an application is understood, repaired, or enhanced. 10-Product type: desktop, web, mobile. 11-Also what is your recommended 3td party tools such as DevExpress,...etc Thank You
EF is bootstrapped (the object model is generated) once in service-based applications, and as often as IIS feels like in IIS-hosted applications. On IIS, the system handles memory management and may pop your application at any time based on usage. As portability, scalability, and interoperability are your key metrics, you'll likely need to roll your own ORM abstraction layer. That layer will need to be able to interface with different platforms (so target .NET Core), and will likely need to be controlled via configuration, and provide an interface that can be implemented across a wide spectrum of technologies (ALL databases also includes document stores, object graphs, and even flat files, just to name a few). That also means that you'll need to build an interface for every platform that you want to talk to. To my knowledge there is no magic "Anything-to-Anything" ORM. My suggestion: narrow your focus so that you can pick suitable technologies. You need an architecture and it's pretty clear that you do not have one. My other suggestion: You have both mobile app and cloud picked as application types. That's inherently nonsensical; that would be at least 2 different applications. One would be a native device app (or possibly several, since you're trying to support multiple platforms) and most likely a RESTful micro-service back-end (which is where your ORM would most likely live).
"There are three kinds of lies: lies, damned lies and statistics." - Benjamin Disraeli
-
Hi, We know First time EF loads metadata into memory, that takes a time and it will be faster in the seconed time because the EF metadata was loaded in the memory, my question is: In the Web Application (MVC or Classic Web Application) is the EF must loaded every request or it is loaded at the first time. Please let me know the Best way to get the Best Performance of the EF. Please let me know what is your recommended technology to use in our system (MVC with EF), (Web Application with ADO.Net),... We need to use a technology with the following criteria: 1- Portability: Run across different platforms 2- Mobility: Mobile application 3- Scalability: Capability to handle growing of work amount (Small, medium, and large business or data). 4- Security: Protect against malicious attack and other hacker risks 5- Cloud 6- Licensing: License price to use the technology 7- Performance 8- DB independence: Could be used with any Database (MS SQL, Oracle, MySQL) 9-Maintainability: The degree to which an application is understood, repaired, or enhanced. 10-Product type: desktop, web, mobile. 11-Also what is your recommended 3td party tools such as DevExpress,...etc Thank You
-
Hi, We know First time EF loads metadata into memory, that takes a time and it will be faster in the seconed time because the EF metadata was loaded in the memory, my question is: In the Web Application (MVC or Classic Web Application) is the EF must loaded every request or it is loaded at the first time. Please let me know the Best way to get the Best Performance of the EF. Please let me know what is your recommended technology to use in our system (MVC with EF), (Web Application with ADO.Net),... We need to use a technology with the following criteria: 1- Portability: Run across different platforms 2- Mobility: Mobile application 3- Scalability: Capability to handle growing of work amount (Small, medium, and large business or data). 4- Security: Protect against malicious attack and other hacker risks 5- Cloud 6- Licensing: License price to use the technology 7- Performance 8- DB independence: Could be used with any Database (MS SQL, Oracle, MySQL) 9-Maintainability: The degree to which an application is understood, repaired, or enhanced. 10-Product type: desktop, web, mobile. 11-Also what is your recommended 3td party tools such as DevExpress,...etc Thank You
zead jalil wrote:
Please let me know the Best way to get the Best Performance of the EF.
Use a different tool. As suggested you should probably roll your own ORM/DAL. What you are asking for is a recommendation for full stack development, not something you can get from a forum post. You need an experienced architect or very senior developer to sit down with you and go over your requirements in detail, probably over a number of days. Then generate a high level design document, that should take a few more days. You are still going to get that persons preferences/prejudices as no one person is going to have detailed knowledge of all the technologies you have covered.
Never underestimate the power of human stupidity RAH