ASP .Net has its own unique ways to work with various Database product. Using ADO .Net developers can do database connection with easy. Also no matter what the DBMS software, the code syntaxes are not too different.
ASP .Net works best with SQL Server. It is no wonder because ASP and SQL Server both comes from Microsoft. But it also can operate with DB2 and other DBMS like Oracle, MySQL, Access etc.