I have a similar question of how to check if you are in a transaction. Instead of checking how do i allow nested transactions?

I am using Microsoft SQL File Database with ADO.NET. I seen examples using tsql and examples starting transactions using begin and using transaction names. When calling connection.BeginTransaction i call another function pass in the same connection and it calls BeginTransaction again which gives me the exception

SqlConnection does not support parallel transactions.

It appears many microsoft variants allow this but i cant figure out how to do it with my .mdf file.

How do i allow nested transactions with a Microsoft SQL File Database using C# and ADO.NET?