Create sql querys Easy in .net for System.Data.SqlClient
##Examples
###Select
DimdbAsSqlConnection()dimsqlasnewSQLBuildersql.Select("*").From("tableName").Database(db).GetSQL()will return
SELECT*FROM tableName###Select Where
DimdbAsSqlConnection()dimsqlasnewSQLBuildersql.Select("*").From("tableName").Where("ID",SqlDbType.Int,SQLBuilder.QueryOperation.Equal,1).Database(db).GetSQL()will return and use SqlParameter for fields
SELECT*FROM tableName WHERE ID = @A###Get SqlCommand
DimdbAsSqlConnection()DimsqlAsNewSQLBuilderUsingcom=sql.Select("*").From("tableName")._Where("ID",SqlDbType.Int,SQLBuilder.QueryOperation.Equal,1)._Database(db).GetSqlCommandUsingdrAsSqlDataReader=com.ExecuteReaderWhiledr.ReadTrace.WriteLine(dr("Name"))Trace.WriteLine(dr("Lastname"))EndWhileEndUsingEndUsing###Insert
DimdbAsSqlConnection()DimsqlAsNewSQLBuilderUsingcom=sql.Insert.Column("Name",SqlDbType.NVarChar,"Marcus")._Column("Lastname",SqlDbType.NVarChar,"lindh").Database(db).GetSqlCommand()Ifcom.ExecuteNonQuery>=1ThenTrace.WriteLine("Added row in db")EndIfEndUsing###Delete
DimdbAsSqlConnection()DimsqlAsNewSQLBuilderUsingcom=sql.Delete.From("TableName").Where("ID",SqlDbType.Int,SQLBuilder.QueryOperation.Equal,1).GetSqlCommand()Ifcom.ExecuteNonQuery>=1ThenTrace.WriteLine("Deleted row(s) in db")EndIfEndUsing###Update
DimdbAsSqlConnection()DimsqlAsNewSQLBuilderUsingcom=sql.Update.From("TableName")._Column("Name",SqlDbType.NVarChar,"Marcus")._Column("lastName",SqlDbType.NVarChar,"Lindh")._Where("ID",SqlDbType.Int,SQLBuilder.QueryOperation.Equal,1).GetSqlCommand()Ifcom.ExecuteNonQuery>=1ThenTrace.WriteLine("Updated row(s) in db")EndIfEndUsing