public static void Connect(string connectionString, AutoCreateOption autoCreateOption)
{
ConnectionString = connectionString;
XpoDefault.DataLayer = XpoDefault.GetDataLayer(ConnectionString, autoCreateOption);
XpoDefault.Session = null;
}
static void Main(string[] args)
{
XpoDefault.DataLayer = XpoDefault.GetDataLayer(
MSSqlConnectionProvider.GetConnectionString("(localdb)\\mssqllocaldb", "ModifyXPQueryTest"),
AutoCreateOption.DatabaseAndSchema);
CreateTestData();
using (var uow = new UnitOfWork()) {
// This works - obviously
//var data = CollectionData(uow);
// This also works - returning data from an XPQuery, but without projection
var data = QueryDataFullObjects(uow);
// This wouldn't work - if the type is not Person, I couldn't modify it
// var data = QueryDataPartialObjects(uow);
ModifyObjects(data);
uow.CommitChanges();
}
OutputData();
}
public static void Initialize(string connectionString, Type sequenceObjectType)
{
_sequenceGenerator = null;
_sequenceObjectType = sequenceObjectType;
_defaultDataLayer = XpoDefault.GetDataLayer(connectionString, AutoCreateOption.None);
RegisterSequences(ApplicationHelper.Instance.Application.TypesInfo.PersistentTypes);
}
private void GetSalesRate()
{
try
{
string sqlquery = "";
sqlquery = " select top 1 price from billdet where prodcode='" + Product.Code + "' and Custcode='" + SalesInvoice.Customer.ERPCode + "' order by bill_date desc";
//Initialize your data layer.
//By default if you don't do this, XPO will try and use an access databse (jet)
Session session = new Session();
XpoDefault.DataLayer = XpoDefault.GetDataLayer(MSSqlConnectionProvider.GetConnectionString(SalesInvoice.Company.ServerName, SalesInvoice.Company.ERPMasterDB + SalesInvoice.Company.Initials), AutoCreateOption.None);
//XpoDefault.DataLayer = XpoDefault.GetDataLayer(MSSqlConnectionProvider.GetConnectionString("ACC00", SalesInvoice.Company.ERPMasterDB + SalesInvoice.Company.Initials), AutoCreateOption.None);
XpoDefault.Session = session;
//Equivalent of SELECT * FROM TableName in SQL
// YourClassName would be your XPO object (your persistent object)
using (var uow = new UnitOfWork())
{
SelectedData sd = uow.ExecuteQuery(sqlquery);
foreach (var item in sd.ResultSet)
{
Price = Convert.ToDecimal(item.Rows[0].Values[0]);
}
}
}
catch (Exception ex) { }
}
public Form1()
{
XpoDefault.DataLayer = XpoDefault.GetDataLayer(AutoCreateOption.DatabaseAndSchema);
CreateDefaultData();
InitializeComponent();
}
static void Main(string[] args)
{
string cs = MSSqlConnectionProvider.GetConnectionString("localhost", "XpoSLExample");
XpoDefault.DataLayer = XpoDefault.GetDataLayer(cs, AutoCreateOption.DatabaseAndSchema);
XpoDefault.Session = null;
try {
using (UnitOfWork uow = new UnitOfWork()) {
uow.UpdateSchema(typeof(Program).Assembly);
uow.CreateObjectTypeRecords(typeof(Program).Assembly);
Person p = uow.FindObject <Person>(null);
if (p == null)
{
new Person(uow)
{
FirstName = "Jake", LastName = "Smith", Birthdate = new DateTime(1990, 10, 1)
};
new Person(uow)
{
FirstName = "Bill", LastName = "Simpson", Birthdate = new DateTime(1982, 2, 20)
};
new Person(uow)
{
FirstName = "Harry", LastName = "Jonathan", Birthdate = new DateTime(1972, 5, 17)
};
uow.CommitChanges();
}
Console.WriteLine("Update successful.");
}
} catch (Exception) {
Console.WriteLine("Update failed.");
}
Console.WriteLine("Press any key...");
Console.ReadKey();
}
static void Main()
{
string conn = MSSqlConnectionProvider.GetConnectionString("(local)", "Northwind");
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.None);
Application.Run(new Form1());
}
private void Click_Edit(object sender, RoutedEventArgs e)
{
try
{
var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
using (var uow = new UnitOfWork(inMemoryDAL))
{
XPQuery <Product_ProductReceive> items = new XPQuery <Product_ProductReceive>(uow);
Product_ProductReceive searchItem = items.FirstOrDefault(i => i.ID == Convert.ToInt32(((Windows.UI.Xaml.Controls.ContentControl)sender).Content.ToString()));
if (!String.IsNullOrEmpty(searchItem.ContainerNo))
{
newContainer.Text = (searchItem.ContainerNo).ToString();
}
if (!String.IsNullOrEmpty(searchItem.DriverName))
{
newDriver.Text = (searchItem.DriverName).ToString();
}
if (!String.IsNullOrEmpty(searchItem.TruckRegistration))
{
newTruckReg.Text = (searchItem.TruckRegistration).ToString();
}
newWbTicket.Text = (searchItem.WBTicket).ToString();
}
}
catch (Exception ex)
{
var msg = ex.Message;
}
}
public MainPage()
{
InitializeComponent();
ThreadPool.QueueUserWorkItem(o => {
XpoDefault.DataLayer = XpoDefault.GetDataLayer(
"http://localhost:64466/Service1.svc",
AutoCreateOption.SchemaAlreadyExists
);
session = new Session();
//It is necessary to call UpdataSchema method for all persistent classes.
session.UpdateSchema(typeof(Customer));
if (session.FindObject(typeof(Customer), new BinaryOperator("ContactName", "Alex Smith", BinaryOperatorType.Equal)) == null)
{
Customer custAlex = new Customer(session)
{
ContactName = "Alex Smith", CompanyName = "DevExpress"
};
custAlex.Save();
Customer Tom = new Customer(session)
{
ContactName = "Tom Jensen", CompanyName = "ExpressIT"
};
Tom.Save();
}
session.TypesManager.EnsureIsTypedObjectValid();
Dispatcher.BeginInvoke(BeginInitializeDataSource);
});
}
/*
* Creates a new DAL with the specified settings and initializes the XpoDefault.DataLayer property.
* As a result, all the units of work (or sessions) will by default access the "Product" database
* using the specified path.
*/
private void InitDAL()
{
XpoDefault.DataLayer = XpoDefault.GetDataLayer(
AccessConnectionProvider.GetConnectionString(@"c:\database\product.mdb"),
AutoCreateOption.DatabaseAndSchema
);
}
public static void InitDAL()
{
string cstr = AccessConnectionProvider.GetConnectionString("database.mdb");
XpoDefault.DataLayer = XpoDefault.GetDataLayer(cstr, AutoCreateOption.DatabaseAndSchema);
DevExpress.Xpo.XpoDefault.Session = null;
}
static IDataLayer SetupDB1()
{
string connString = MSSqlConnectionProvider.GetConnectionString("(local)", "SampleDB1");
XPDictionary dict = new ReflectionDictionary();
dict.CollectClassInfos(typeof(Contact));
IDataLayer dal = XpoDefault.GetDataLayer(connString, dict, AutoCreateOption.DatabaseAndSchema);
using (UnitOfWork uow = new UnitOfWork(dal)) {
uow.UpdateSchema(typeof(Contact));
if (uow.FindObject <Contact>(null) == null)
{
Contact contact1 = new Contact(uow)
{
FirstName = "John", LastName = "Doe"
};
Contact contact2 = new Contact(uow)
{
FirstName = "Paul", LastName = "Smith"
};
uow.CommitChanges();
}
}
return(dal);
}
public void updateRecord(int id)
{
var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
id = RecId;
try
{
using (var uow = new UnitOfWork(inMemoryDAL))
{
Order_OrderIn searchItem = new XPQuery <Order_OrderIn>(uow).FirstOrDefault(i => i.ID.Equals(lblOrderNo.Text));
//ExpectedTrucks searchTruck = new XPQuery<ExpectedTrucks>(uow).FirstOrDefault(i => i.ID == Convert.ToInt32(lblExpTruck.Text));
//Library_Supplier L_SearchItem = new XPQuery<Library_Supplier>(uow).FirstOrDefault(i => i.Name == (SupplierComboBox.SelectedValue.ToString()));
Library_Transporter LT_SearchItem = new XPQuery <Library_Transporter>(uow).FirstOrDefault(i => i.Name == (TransComboBox.SelectedValue.ToString()));
Product_ProductReceive pr = new XPQuery <Product_ProductReceive>(uow).FirstOrDefault(i => i.ID.Equals(id));
tar = Convert.ToDouble(txtTar.Text);
gross = Convert.ToDouble(txtGross.Text);
txtNett.Text = calcNettWeight(tar, gross).ToString();
pr.TarWeight = tar;
pr.GrossWeight = gross;
pr.NettWeight = calcNettWeight(tar, gross);
//pr.SupplierID = L_SearchItem;
pr.RecOrderID = searchItem;
//pr.ExpectedID = searchTruck;
pr.TransporterID = LT_SearchItem;
//pr.DateModified = DateTime.Now;
pr.DriverName = newDriver.Text;
pr.NettWeight = calcNettWeight(Convert.ToDouble(txtGross.Text), Convert.ToDouble(txtNett.Text));
uow.CommitChanges();
}
}
catch (Exception ex)
{
}
}
public void PopulateTransCombobox()
{
var inMemoryDAL = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
try
{
using (var uow = new UnitOfWork(inMemoryDAL))
{
XPCollection <Library_Transporter> Library_Transporters = new XPCollection <Library_Transporter>(uow);
//LookupEdit2.ItemsSource = new XPCollection<Order_OrderIn>(uow);
var list = Library_Transporters.Select(i => new { ID = (i.ID).ToString(), Name = i.Name }).ToList();
foreach (var item in list.Distinct())
{
ComboBoxItem comboItem = new ComboBoxItem();
comboItem.Content = item.Name;
comboItem.Tag = item.ID;
TransComboBox.Items.Add(comboItem);
}
}
}
catch (Exception ex)
{
var msg = ex.Message;
}
}
public Form1()
{
InitializeComponent();
try
{
SecurityUser user = new SecurityUser();
user.ReadConnection("Nour", "Nour");
XpoDefault.DataLayer = XpoDefault.GetDataLayer(user.ConnectionString, DevExpress.Xpo.DB.AutoCreateOption.SchemaOnly);
SecurityUser.CurrentUser = user;
SecurityUser.IsConnected = true;
Session s = new Session();
List <XPClassInfo> lst = new List <XPClassInfo>()
{
Session.DefaultSession.GetClassInfo(typeof(CoreLib.Grid.UserProfile.UIMaster)),
Session.DefaultSession.GetClassInfo(typeof(CoreLib.Grid.UserProfile.UIParams)),
Session.DefaultSession.GetClassInfo(typeof(CoreLib.Grid.UserProfile.UIProfile)),
Session.DefaultSession.GetClassInfo(typeof(CoreLib.Grid.UserProfile.UIProfileLine))
};
//s.UpdateSchema();
Assembly a = Assembly.GetAssembly(typeof(CoreLib.MyForm));
s.UpdateSchema(a);
myGridView1.UnitOfWorkXpo = unitOfWork1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
static void Main(string[] args)
{
byte[] data = new byte[5] {
5, 4, 3, 2, 1
};
XpoDefault.DataLayer = XpoDefault.GetDataLayer(AutoCreateOption.DatabaseAndSchema);
//new Session().ClearDatabase();
using (UnitOfWork uof = new UnitOfWork()) {
if (uof.FindObject <MyObject>(null) == null)
{
Console.WriteLine("Creating a default object...");
MyObject obj = new MyObject(uof);
obj.Name = "pict";
obj.DocumentInternal = data;
uof.CommitChanges();
}
}
using (UnitOfWork uof = new UnitOfWork()) {
Console.WriteLine("Loading MyObject...");
MyObject obj = uof.FindObject <MyObject>(null);
Console.WriteLine(obj.Name);
byte[] loaded = obj.Document;
Console.WriteLine(loaded.Length);
}
Console.WriteLine("Press <Enter> to exit.");
Console.ReadLine();
}
private void simpleAction1_Execute(object sender, SimpleActionExecuteEventArgs e)
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;Data Source=TestProject.mdb;Mode=Share Deny None;";
XpoDefault.DataLayer = XpoDefault.GetDataLayer(connectionString, AutoCreateOption.DatabaseAndSchema);
Session session = new Session();
for (int i = 1; i < 101; i++)
{
Airport a = new Airport(session);
a.NameOfAirport = "Аэропорт" + i.ToString();
Pilot b = new Pilot(session);
b.FullName = "Пилот" + i.ToString();
Pilot c = new Pilot(session);
c.FullName = "Pilot" + i.ToString();
Plane d = new Plane(session);
d.NameOfPlane = "Самолет" + i.ToString();
b.Planes.Add(d);
c.Planes.Add(d);
b.Airport = a;
c.Airport = a;
d.Airport = a;
a.Save();
b.Save();
c.Save();
d.Save();
}
}
public static IDataLayer GetDataLayer()
{
XpoDefault.Session = null;
var uow = XpoHelper.GetNewUnitOfWork();
var sqlConnection = uow.FindObject <SQLConnection>(CriteriaOperator.Parse("Oid==?", 1));
//string conn = MySqlConnectionProvider.GetConnectionString("localhost", "root", "", "CUFE");
string sqlConnectionString = MSSqlConnectionProvider.GetConnectionString(sqlConnection.IP, sqlConnection.user, sqlConnection.password, sqlConnection.Datenbank);
//string conn = System.Configuration.ConfigurationManager.ConnectionStrings[sqlConnectionString].ConnectionString;
XPDictionary dict = new ReflectionDictionary();
IDataStore store = XpoDefault.GetConnectionProvider(sqlConnectionString, AutoCreateOption.None);
//DevExpress.Xpo.Metadata.ReflectionClassInfo.SuppressSuspiciousMemberInheritanceCheck = true;
//dict.GetDataStoreSchema(typeof(Inscripcion).Assembly);
//IDataLayer dl = new ThreadSafeDataLayer(dict, store);
////using (UnitOfWork uow = new UnitOfWork(dl))
////{
//// int cnt = (int)uow.Evaluate<CUFE.Models.Country>(CriteriaOperator.Parse("count"), null);
//// if (cnt == 0)
//// {
//// new CUFE.Models.Country(uow) { CountryName = "Germany" };
//// uow.CommitChanges();
//// }
////}
//return dl;
return(XpoDefault.GetDataLayer(sqlConnectionString, AutoCreateOption.SchemaAlreadyExists));
}
public static void Seed()
{
string connStr = ConfigurationManager.ConnectionStrings["XpoTutorial"].ConnectionString;
var dataLayer = XpoDefault.GetDataLayer(connStr, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
using (UnitOfWork uow = new UnitOfWork(dataLayer)) {
if (uow.Query <RevenueAnalysisDataItem>().Count() > 0)
{
return;
}
int year = DateTime.Today.Year;
for (int i = 0; i < 1000; i++)
{
ProductCategory category = productCategories[rnd.Next(productCategories.Length)];
RevenueAnalysisDataItem item = new RevenueAnalysisDataItem(uow)
{
Category = category.Category,
Product = category.Products[rnd.Next(category.Products.Length)],
State = states[rnd.Next(states.Length)],
UnitsSold = rnd.Next(5, 100),
Revenue = rnd.Next(5, 100),
Year = rnd.Next(year - 5, year + 1)
};
}
uow.CommitChanges();
}
}
static void Main(params string[] args)
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
try
{
var config = System.Configuration.ConfigurationManager.OpenExeConfiguration(System.Configuration.ConfigurationUserLevel.PerUserRoamingAndLocal);
var sqlConn = config.ConnectionStrings.ConnectionStrings["Model22"].ConnectionString;
XpoDefault.DataLayer = XpoDefault.GetDataLayer(sqlConn, AutoCreateOption.None);
if (XpoDefault.DataLayer != null)
{
XpoDefault.Session.ExecuteNonQuery(@" ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA' NLS_ISO_CURRENCY= 'AMERICA' NLS_DATE_FORMAT= 'DD/MM/RRRR' NLS_DATE_LANGUAGE= 'AMERICAN' NLS_SORT= 'BINARY' ");
Login.USUARIO_ID = ObterUsuario(args);
Login.FILIALCONECTADA = new FILIAL().GetFilialConectada(Login.USUARIO_ID, Environment.MachineName);
Login.CONECTADO = true;
}
Application.Run(new MainForm());
}
catch (Exception ex)
{
Util.ShowMessageError(ex);
}
}
public static void Tests(string dbName, string connectionString) => Describe($"{nameof(XPUserStore<IdentityUser, string, IdentityUserClaim<string>, IdentityUserLogin<string>, IdentityUserToken<string>, XpoIdentityUser, XpoIdentityRole, XpoIdentityUserClaim, XpoIdentityUserLogin, XpoIdentityUserToken>)} using {dbName}", () =>
{
var dataLayer = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
UnitOfWork unitOfWorkFactory() => new UnitOfWork(dataLayer);
(XPUserStore <IdentityUser, string, IdentityUserClaim <string>, IdentityUserLogin <string>, IdentityUserToken <string>, XpoIdentityUser, XpoIdentityRole, XpoIdentityUserClaim, XpoIdentityUserLogin, XpoIdentityUserToken> store, UnitOfWork uow)CreateStore()
{
var uow = new UnitOfWork(dataLayer);
var store = new XPUserStore <
IdentityUser,
string,
IdentityUserClaim <string>,
IdentityUserLogin <string>,
IdentityUserToken <string>,
XpoIdentityUser,
XpoIdentityRole,
XpoIdentityUserClaim,
XpoIdentityUserLogin,
XpoIdentityUserToken
>(
uow,
new FakeLogger <XPUserStore <IdentityUser, string, IdentityUserClaim <string>, IdentityUserLogin <string>, IdentityUserToken <string>, XpoIdentityUser, XpoIdentityRole, XpoIdentityUserClaim, XpoIdentityUserLogin, XpoIdentityUserToken> >(),
new IdentityErrorDescriber()
);
return(store, uow);
}
XpoIdentityUser CreateUser(UnitOfWork uow, string id = null) => new XpoIdentityUser(uow)
private static IDataLayer GetDataLayer()
{
return(XpoDefault.GetDataLayer(_connectionString, AutoCreateOption.DatabaseAndSchema));
//Use below code when want to use WCF service for cache data store.
//return XpoDefault.GetDataLayer("http://localhost:59370/DataService.svc", AutoCreateOption.DatabaseAndSchema);
}
protected void Session_Start(Object sender, EventArgs e)
{
Tracing.Initialize();
WebApplication.SetInstance(Session, new DoSoReportingAspNetApplication());
DevExpress.ExpressApp.Web.Templates.DefaultVerticalTemplateContentNew.ClearSizeLimit();
WebApplication.Instance.SwitchToNewStyle();
if (ConfigurationManager.ConnectionStrings["ConnectionString"] != null)
{
WebApplication.Instance.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
}
XpoDefault.DataLayer = XpoDefault.GetDataLayer(WebApplication.Instance.ConnectionString, DevExpress.Xpo.DB.AutoCreateOption.SchemaAlreadyExists);
#if EASYTEST
if (ConfigurationManager.ConnectionStrings["EasyTestConnectionString"] != null)
{
WebApplication.Instance.ConnectionString = ConfigurationManager.ConnectionStrings["EasyTestConnectionString"].ConnectionString;
}
#endif
if (System.Diagnostics.Debugger.IsAttached && WebApplication.Instance.CheckCompatibilityType == CheckCompatibilityType.DatabaseSchema)
{
WebApplication.Instance.DatabaseUpdateMode = DatabaseUpdateMode.UpdateDatabaseAlways;
}
WebApplication.Instance.Setup();
WebApplication.Instance.Start();
}
public static void Tests(string name, string connectionString) => Describe($"{nameof(TrialRequestCommandHandler)} using {name}", () =>
{
var dataLayer = XpoDefault.GetDataLayer(connectionString, DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
using var unitOfWork = new UnitOfWork(dataLayer);
var settings = unitOfWork.CreateDefaultSettings();
unitOfWork.UpdateSchema();
unitOfWork.Save(settings);
unitOfWork.CommitChanges();
async Task <TrialRequestResult> ExecuteCommand(TrialRequestCommand command)
{
using var uow = new UnitOfWork(dataLayer);
return(await new TrialRequestCommandHandler(uow).ExecuteAsync(command));
}
Describe("can request a trial", () =>
{
It("With normal user", async() =>
{
var trial = await ExecuteCommand(new TrialRequestCommand(Guid.NewGuid().ToString(), Guid.NewGuid().ToString(), null, null));
trial.ShouldSatisfyAllConditions(
() => trial.ShouldNotBeNull(),
() => trial.Id.ShouldNotBe(default),
() => trial.ExpiresAt.Date.ShouldBe(DateTime.Today.AddDays(settings.DefaultTrialPeriod)),
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
XpoDefault.TrackPropertiesModifications = true;
SafePostgreSqlConnectionProvider.Register();
XpoDefault.DataLayer = XpoDefault.GetDataLayer(Configuration.GetConnectionString("DXConnection"), DevExpress.Xpo.DB.AutoCreateOption.None);
services.AddScoped <UnitOfWork>();
var result = typeof(BlBase <>).Assembly
.GetTypes()
.Where(t => t.ParentTypes().Any(p => p.IsGenericType && p.GetGenericTypeDefinition() == typeof(BlBase <>)));
foreach (var type in result)
{
services.AddScoped(type);
}
services.AddScoped <IApiService, ApiService>();
services.AddScoped(typeof(IRepositoryID <>), typeof(DBRepository <>));
services.AddSwaggerGen(c =>
{
c.SwaggerDoc("v1", new Info {
Title = "My API", Version = "v1"
});
});
}
static void Main(string[] args)
{
XpoDefault.DataLayer = XpoDefault.GetDataLayer("http://localhost:55777/Service1.svc", AutoCreateOption.DatabaseAndSchema);
XpoDefault.Session = null;
using (UnitOfWork uow = new UnitOfWork()) {
if (uow.FindObject(typeof(Customer), new BinaryOperator("ContactName", "Alex Smith", BinaryOperatorType.Equal)) == null)
{
Customer custAlex = new Customer(uow);
custAlex.ContactName = "Alex Smith";
custAlex.CompanyName = "DevExpress";
custAlex.Save();
Customer Tom = new Customer(uow);
Tom.ContactName = "Tom Jensen";
Tom.CompanyName = "ExpressIT";
Tom.Save();
uow.CommitChanges();
}
using (XPCollection <Customer> customers = new XPCollection <Customer>(uow)) {
foreach (Customer customer in customers)
{
Console.WriteLine("Company Name = {0}; ContactName = {1}", customer.CompanyName, customer.ContactName);
}
}
}
Console.WriteLine("Press any key...");
Console.ReadKey();
}
private static void InitDAL()
{
XpoDefault.DataLayer = XpoDefault.GetDataLayer(
@"XpoProvider=MSSqlServer;data source=(local);integrated security=SSPI;initial catalog=E771",
DevExpress.Xpo.DB.AutoCreateOption.DatabaseAndSchema);
XpoDefault.Session = null;
}
//Dennis: It is important to set the SequenceGenerator.DefaultDataLayer property to the main application data layer.
//If you use a custom IObjectSpaceProvider implementation, ensure that it exposes a working IDataLayer.
public static void Initialize()
{
Guard.ArgumentNotNull(Application, "Application");
XPObjectSpaceProvider provider = Application.ObjectSpaceProvider as XPObjectSpaceProvider;
if (provider != null)
{
Guard.ArgumentNotNull(provider, "provider");
if (provider.DataLayer == null)
{
provider.CreateObjectSpace();
}
if (provider.DataLayer is ThreadSafeDataLayer)
{
SequenceGenerator.DefaultDataLayer = XpoDefault.GetDataLayer(
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString,
XpoTypesInfoHelper.GetXpoTypeInfoSource().XPDictionary,
DevExpress.Xpo.DB.AutoCreateOption.None);
}
else
{
SequenceGenerator.DefaultDataLayer = provider.DataLayer;
}
}
}
private static void ConxionBaseDeDatos()
{
//Bases de datos soportadas
//https://documentation.devexpress.com/#CoreLibraries/CustomDocument2114
//Ejemplos de conexion para todas las bases de XPO
//https://www.devexpress.com/Support/Center/Question/Details/K18445
//Conexion a access, el provedor esta en el namspace DevExpress.Xpo.DB, alli estan los demas proveedores, como OracleConnectionProvider o MSSqlConnectionProvider
//estos proveedores son clases estaticas que tiene un metodo para crear la cadena de conexion, esta cadena tambien se puede crear a mano segun los ejemplos de el link
//https://www.devexpress.com/Support/Center/Question/Details/K18445 o con la clase estatica segun los ejemplos de este link
https: //documentation.devexpress.com/#CoreLibraries/CustomDocument3243
//TODO quitar el comentario para usar access o mysql
//Access
//string conn = AccessConnectionProvider.GetConnectionString(@"EjemplosXPO.mdb");
//MySQL
string conn = MySqlConnectionProvider.GetConnectionString("localhost", "root", "JoseManuel16", "EjemplosXPO");
//TIP # 3. Explicitly set the XpoDefault.DataLayer property in the entry point of your application.
//https://www.devexpress.com/Support/Center/Question/Details/A2944
XpoDefault.DataLayer = XpoDefault.GetDataLayer(conn, AutoCreateOption.DatabaseAndSchema);
}
/// <summary>
/// It does load database connection.
/// </summary>
public static void LoadingDatabaseConnection()
{
try {
// Database connection string properties.
var server = @"ALBERTO-PC\SQL";
var dbUser = "******";
var dbPassword = "******";
var dbName = "XpoTestDatabase";
// It does create the database connection and bring back the unit of work that will be used.
var connection = MSSqlConnectionProvider.GetConnectionString(server, dbUser, dbPassword, dbName);
var dataLayerLocal = XpoDefault.GetDataLayer(connection, AutoCreateOption.DatabaseAndSchema);
var unitOfWork = new UnitOfWork(dataLayerLocal);
unitOfWork.Connect();
// It does update database structure.
unitOfWork.UpdateSchema();
// It does create a new user.
var user = new User(unitOfWork);
user.UserName = "******";
user.Password = "******";
// It does persist new user data in datbase.
unitOfWork.CommitChanges();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
}
