EasySQL

Create sql querys Easy in .net for System.Data.SqlClient

##Examples

###Select

Dim db As SqlConnection()
dim sql as new SQLBuilder

sql.Select("*").From("tableName").Database(db).GetSQL()

will return

SELECT * FROM tableName

###Select Where

Dim db As SqlConnection()
dim sql as new SQLBuilder

sql.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

Dim db As SqlConnection()
Dim sql As New SQLBuilder
    
Using com = sql.Select("*").From("tableName"). _
    Where("ID", SqlDbType.Int, SQLBuilder.QueryOperation.Equal, 1). _
    Database(db).GetSqlCommand
        
    Using dr As SqlDataReader = com.ExecuteReader
        While dr.Read
            Trace.WriteLine(dr("Name"))
            Trace.WriteLine(dr("Lastname"))
        End While
    End Using
End Using

###Insert

Dim db As SqlConnection()
Dim sql As New SQLBuilder
    
Using com = sql.Insert.Column("Name", SqlDbType.NVarChar, "Marcus"). _
    Column("Lastname", SqlDbType.NVarChar, "lindh").Database(db).GetSqlCommand()

    If com.ExecuteNonQuery >= 1 Then
        Trace.WriteLine("Added row in db")
    End If
End Using

###Delete

Dim db As SqlConnection()
Dim sql As New SQLBuilder
    
Using com = sql.Delete.From("TableName").Where("ID", SqlDbType.Int, SQLBuilder.QueryOperation.Equal, 1).GetSqlCommand()

    If com.ExecuteNonQuery >= 1 Then
        Trace.WriteLine("Deleted row(s) in db")
    End If
End Using

###Update

Dim db As SqlConnection()
Dim sql As New SQLBuilder
    
Using com = sql.Update.From("TableName"). _
    Column("Name", SqlDbType.NVarChar, "Marcus"). _
    Column("lastName", SqlDbType.NVarChar, "Lindh"). _
    Where("ID", SqlDbType.Int, SQLBuilder.QueryOperation.Equal, 1).GetSqlCommand()

    If com.ExecuteNonQuery >= 1 Then
        Trace.WriteLine("Updated row(s) in db")
    End If
End Using