0

How to use ADO.NET with the multi tenant application. I would like to to use ado.net with SQL server. please advise if there are any samples.

Lokesh B R
  • 272
  • 1
  • 8
  • I do not think so it will come with ADO.Net because they have created framework and by default they have provided entity framework code first approach – Darshan Dave Apr 23 '18 at 04:14

2 Answers2

2

Just create a custom repository and use SQL inside it.

Check this article for more: http://www.aspnetboilerplate.com/Pages/Documents/Articles/Using-Stored-Procedures,-User-Defined-Functions-and-Views/index.html It also uses SP and views.

hikalkan
  • 2,234
  • 15
  • 17
1

Your choices are:

  • EF Core
  • EF
  • Dapper
  • NHibernate

If performance is top priority for you Dapper may be of interest.

jazb
  • 5,498
  • 6
  • 37
  • 44