convert a sql statement to class?
- by walter
Is there a tool or code to convert a sql statement to class?
Something like:
Dim sqlText = "SELECT CustomerID, Name, Address, City FROM dbo.Customer WHERE CustomerID = 1"
Dim obj As New ***SqlStatementTool***(sqlText)
obj.GetTables() 'Will Return Tables in sqlText
obj.GetWheres() 'Will Return conditions in sqltext
obj.GetParameters() 'will return parameters in sqltext