Ready to Xamarin & .NET Core, Database Library for Microsoft SQL Server.
It's Database Access Library for Microsoft SQL Server.
based on Xb.Db
SQL Command execution, Transaction management, and Simple implementation of Table-Model.
Supports .NET4.5.1, .NET Standard1.3
System.Data.Common
System.Data.SqlClient
Xb.Core
Xb.Db
- Add NuGet Package to your project.
- Create instance
var db = new Xb.Db.MsSql("DatabaseName", "UserName", "Password", "HostName"); - Get model
var model = db.Models["TableName"]; - do any()
Namespace and Methods are...
・Xb.Db
|
+- .MsSql(Instance)
| |
| +- .Constructor(string name,
| | string user = "sa",
| | string password = "sa",
| | string address = "localhost",
| | string additionalString = "",
| | bool isBuildModels = true,
| | Encoding encoding = null)
| | Create instance
| |
| +- .Constructor(SqlConnection connection,
| | bool isBuildModels = true
| | Encoding encoding = null)
| | Create instance of DbConnection-Reference
| |
| +- .GetParameter(string name = null,
| | object value = null,
| | SqlDbType type = SqlDbType.VarChar)
| | Get DbParameter-object for Sql-Query
| |
| +- .Quote(string text,
| | LikeMarkPosition likeMarkPos = LikeMarkPosition.None)
| | Get Quoted-String for SQL value
| |
| +- .Execute(string sql,
| | DbParameter[] parameters = null)
| | Execute Non-Select query, Get effected row count
| |
| +- .ExecuteAsync(string sql,
| | DbParameter[] parameters = null)
| | Execute Non-Select query on async, Get effected row count
| |
| +- .GetReader(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query, Get DbDataReader object.
| |
| +- .GetReaderAsync(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query on async, Get DbDataReader object.
| |
| +- .Query(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query, Get Xb.Db.ResultTable
| |
| +- .QueryAsync(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query on async, Get Xb.Db.ResultTable(like DataTable)
| |
| +- .Query<T>(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query, Get array of Generic-Type object.
| |
| +- .QueryAsync<T>(string sql,
| | DbParameter[] parameters = null)
| | Execute Select query on async, Get Generic-Type object.
| |
| +- .Find(string tableName,
| | string whereString)
| | Get first matched Xb.Db.ResultRow(like DataRow)
| |
| +- .FindAsync(string tableName,
| | string whereString)
| | Get first matched Xb.Db.ResultRow(like DataRow) on async
| |
| +- .FindAll(string tableName,
| | string whereString = null,
| | string orderString = null)
| | Get matched all rows(Xb.DbResultTable, like DataTable)
| |
| +- .FindAllAsync(string tableName,
| | string whereString = null,
| | string orderString = null)
| | Get matched all rows(Xb.DbResultTable, like DataTable) on async
| |
| +- .BeginTransaction()
| | Start transaction
| |
| +- .BeginTransactionAsync()
| | Start transaction on async
| |
| +- .CommitTransaction()
| | Commit transaction
| |
| +- .CommitTransactionAsync()
| | Commit transaction on async
| |
| +- .RollbackTransaction()
| | Rollback transaction
| |
| +- .RollbackTransactionAsync()
| | Rollback transaction on async
| |
| +- .BackupDbAsync(string fileName)
| Get Database backup file on async
|
|
+- .Model(Instance)
|
+- .Constructor(Xb.Db.DbBase db,
| Xb.Db.DbBase.Structure[] infoRows)
| Create instance of Table-Model
|
+- .GetColumn(string columnName)
| Get Xb.Db.Model.Column-object by name
|
+- .GetColumn(int index)
| Get Xb.Db.Column object by index
|
+- .Find(object primaryKeyValue)
| Get first matched Xb.Db.ResultRow(like DataRow)
|
+- .Find(params object[] primaryKeyValues)
| Get first matched Xb.Db.ResultRow(like DataRow)
|
+- .FindAsync(object primaryKeyValue)
| Get first matched Xb.Db.ResultRow(like DataRow) on async
|
+- .FindAsync(params object[] primaryKeyValues)
| Get first matched Xb.Db.ResultRow(like DataRow) on async
|
+- .FindAll(string whereString = null,
| string orderString = null)
| Get matched Xb.Db.ResultTable(like DataTable)
|
+- .FindAllAsync(string whereString = null,
| string orderString = null)
| Get matched Xb.Db.ResultTable(like DataTable) on async
|
+- .NewRow()
| Get new Xb.Db.ResultRow for CRUD
|
+- .Validate(Xb.Db.ResultRow row)
| Validate values of Xb.Db.ResultRow
|
+- .Write(Xb.Db.ResultRow row,
| params string[] excludeColumnsOnUpdate)
| Write value of Xb.Db.ResultRow to Database
|
+- .WriteAsync(Xb.Db.ResultRow row,
| params string[] excludeColumnsOnUpdate)
| Write value of Xb.Db.ResultRow to Database on async
|
+- .Insert(Xb.Db.ResultRow row)
| Execute [INSERT] SQL-Command
|
+- .InsertAsync(Xb.Db.ResultRow row)
| Execute [INSERT] SQL-Command on async
|
+- .Update(Xb.Db.ResultRow row,
| string[] keyColumns = null,
| string[] excludeColumns = null)
| Execute [UPDATE] SQL-Command
|
+- .UpdateAsync(Xb.Db.ResultRow row,
| string[] keyColumns = null,
| string[] excludeColumns = null)
| Execute [UPDATE] SQL-Command on async
|
+- .Delete(Xb.Db.ResultRow row,
| params string[] keyColumns)
| Execute [DELETE] SQL-Command
|
+- .DeleteAsync(Xb.Db.ResultRow row,
| params string[] keyColumns)
| Execute [DELETE] SQL-Command on async
|
+- .ReplaceUpdate(List<Xb.Db.ResultRow> drsAfter,
| List<Xb.Db.ResultRow> drsBefore = null,
| params string[] excludeColumnsOnUpdate)
| Update the difference of new-rows and old-rows
|
+- .ReplaceUpdate(Xb.Db.ResultTable dtAfter,
| Xb.Db.ResultTable dtBefore = null,
| params string[] excludeColumnsOnUpdate)
| Update the difference of new-rows and old-rows
|
+- .ReplaceUpdateAsync(List<Xb.Db.ResultRow> drsAfter,
| List<Xb.Db.ResultRow> drsBefore = null,
| params string[] excludeColumnsOnUpdate)
| Update the difference of new-rows and old-rows on async
|
+- .ReplaceUpdateAsync(Xb.Db.ResultTable dtAfter,
Xb.Db.ResultTable dtBefore = null,
params string[] excludeColumnsOnUpdate)
Update the difference of new-rows and old-rows on async