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); }