I need to execute a sql query from within a c# class. I have thought of 2 options
- Starting a process of sqlcmd.
- Using a SqlCommand object.
My question is which would be the better way? It's important that the solution only holds a connection to the server for a short time.
I'm open to other ideas if the above aren't good.
Thanks in advance.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…