public void SQLServerProviderConnection()
{
DataProviderBase provider = new SQLServerDataProvider(new ConnectionParams()
{
ConnectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=Test;Integrated Security=SSPI;AttachDBFilename=D:\Programming\DB\Test.mdf"
});
provider.Open();
Assert.IsTrue(provider.IsOpen);
provider.Close();
}
public void SQLServerInsert()
{
DataProviderBase provider = new SQLServerDataProvider(new ConnectionParams()
{
ConnectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=Test;Integrated Security=SSPI;AttachDBFilename=D:\Programming\DB\Test.mdf"
});
provider.Open();
User user = new User()
{
Username = "******",
AccessToken = "",
EmailAddress = "*****@*****.**",
Id = 23,
IsValid = true
};
DataPayload<User> payload = new DataPayload<User>()
{
Entity = user,
Identifier = null
};
DataResult result = provider.Execute(Operation.Insert, payload);
}
