convert a sql statement to class?

Question

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

Answer 1

Essentially, you are describing an Object-Relational Mapper. There are many good ones out there, such as NHibernate, Linq to SQL, Entity Framework, etc.

Answer 2

That would have to be something coded specifically for your particular database software, since every database has its own flavor of SQL. For instance, you might use implicit joins instead of explicit joins. It doesn't sound too difficult to implement though.

Answer 3

another way to possibly do that is to make your statement a view and use an O/RM mapping tool.

Answer 4

Is it possible using EF4?

Answer 5

Yes, there are such avaiable, You can think of Hiberante for Java