hello my friend.
maybe my question is not right about this part of forum but i think its better to be asked here.
i have a windows server and is written with c#. i work with sql server for working with data. there is a question for me. is most of us know working with orm like entity framework is very sugested against of using string query and sql command and dataset.
i dont have very bright information but its said that EF uses a localDB to save recent data and in certain amount of time, it will add the data to main sql server database. maybe it makes connections with database much less and maybe less exceptions. but doesnt it use more buffer for localDB? or as my database also is on same server is this really important to be worried about server and database?
its said that using and orm compeletly defeats the sql injection and there will be no sql injection threat . is this true?
i have worked alot with sqlcommand and i just started working with EF. i think i can make much cleaner code using sqlcommand rather than EF.
which of them is faster and uses less memory and process?
maybe there are more diffrences that i dont know.
i ant to know what you think about it and what is your opinion about this?
thank you for helping.