在vb.net命令结果中保持SQL位为0/1，而不是布尔值

CREATE TABLE YourTable
(
    BitColumn bit
)

Dim bitValue As Boolean = True ' 设置为0或1

Using connection As New SqlConnection("YourConnectionString")
    connection.Open()
    
    Dim commandText As String = "INSERT INTO YourTable (BitColumn) VALUES (@BitValue)"
    Dim command As New SqlCommand(commandText, connection)
    command.Parameters.AddWithValue("@BitValue", bitValue)
    
    command.ExecuteNonQuery()
End Using

Using context As New YourDbContext()
    Dim entity As New YourEntity()
    entity.BitColumn = bitValue
    
    context.YourTable.Add(entity)
    context.SaveChanges()
End Using