Best practices for SQL query

[LeonR]

Out of interest, how are people managing their query strings from within a vb.net?

I am currently using a function (method) in a class object, and simply parseing the string to the function, either add or get data.
Obviously doing this means you end up with alot of hardcoded stuff in the application, like mystring="select " & textbox & " from" etc etc...

This looks messy to me? One option would be to write a few functions which you then send the parameters?

I like to do things tidy, and keep it simple so wondered how people were getting around this

Thanks,
Leon

 

[jmcilhinney]

Use the Entity Framework. Have the IDE generate a model and then use LINQ to write all your queries.

 

[LeonR]

Excellent, thanks!

I just need to get SQL server to show up in my connection list now! grrrr..