What is best and latest approach by web developer at mnc

Question

Currently am developing and web application and i want to make as effient as well in the term of resources it will use in asp.net either by webforms or in MVC.When ever i am fetching data from my MS Sql Db what would be best approach to have it in Collections like List and many more or i should fetch it in datatable or dataset.Tell me about what mnc developers are using currently

Shrimant Telgave · Answer

As per my perspective collection is better than datatable/dataset Following are the advantages of collection over datatable. DataTable stores boxed objects, and one needs to unbox values when needed. This adds overhead on the runtime environment. However, values in generic collections are strongly typed, so no boxing involved. Unboxing happens at runtime, as does the type checking. If there is a mismatch between types of source and target, it leads to a runtime exception. This may lead to a number of issues while using DataTables. In case of collections, as the types are checked at the compile time, such type mismatches are caught during compilation. .NET languages got very nice support for creating collections, like object initializer and collection initializer. We don’t have such features for DataTables. LINQ queries can be used on both DataTables and collections. But the experience of writing the queries on generic collections is better because of IntelliSense support provided by Visual Studio. DataTables are framework specific; we often see issues with serializing and de-serializing them in web services. Generic collections are easier to serialize and de-serialize, so they can be easily used in any service and consumed from a client written in any language. ORMs are becoming increasingly popular, and they use generic collections for all data operations. Mocking DataTables in unit tests is a pain, as it involves creating the structure of the table wherever needed. But a generic collection needs a class defined just once.

Shrimant Telgave · Answer

Hello Ashish As per the requirement, you can use either 'ASP.NET' or ASP.NET MVC. But MVC is better than ASP.NET. MVC has high performance as compare to asp.net. We can not say MNC developer can use this and that. They are using as per there requirement. But now a days we are using either MVC or ASP.NET Core.

Ashish Mishra · Answer

But sir what i should prefer from performance point of view datatable / dataset or Collections like List in MVC while using Ntier or ThreeTier architecture ..... any suggestion