That'll of course depend completely on the nature of the things you do with those records you get from the database, but 1M recors don't seem like much (do you join them with something?).

But if LINQ is what you need, well, Python may have a similar or not, depending on how you use it, but there is no reason for you to start writting C# in Python.