Database Requirements

# Database Requirements

To work with LogicPos we need a data store, currently we can use MySql Server, Miscrosoft SqlServer or Sqlite, bu technically we can use any data source comopatible with eXpressPersistent Objects™ (XPO)

> Note

To work with MySql Server or Miscrosoft SqlServer we need first to install server To Work With Sqlite we dont need to install anything Tip

### Recommended data sources: Mysql and SqlServer Configure LogicPos Database Connection After we choose a data store we need to configure it in application config

Open and edit config logicpos\bin\Debug\logicpos.exe.config

Configure Database

## Option #1 : Mysql

To work with MySql we need to edit xpoConnectionString to connect to local or remote MySql Server Instance

<add key="databaseType" value="MySql" />

<add key="xpoConnectionString" value="XpoProvider=MySql;server=localhost;database={0};user id=root;password=PASSWORD;persist security info=true;CharSet=utf8;" />

Note For remote server change localhost with remote ip, for ex 192.168.1.1

## Option #2 : SqlServer

To work with SqlServer we need to edit xpoConnectionString to point to our SqlServer Server Instance

<add key="databaseType" value="MSSqlServer" />

<add key="xpoConnectionString" value="XpoProvider=MSSqlServer;Data Source=SERVER\sql2008;Initial Catalog={0};User ID=sa;Password=PASSWORD;Persist Security Info=true;" />

## Option #3 : SqlServer Express

To work with SqlServer Express we need to edit xpoConnectionString to point to our SqlServer Express Instance, the connection string is a little diferent

<add key="databaseType" value="MSSqlServer" />

<add key="xpoConnectionString" value="XpoProvider=MSSqlServer;Data Source=.\SQLEXPRESS;Initial Catalog={0};User ID=username;Password=password;Persist Security Info=true;Integrated Security=SSPI;Pooling=false;" />

## Option #4 : Sqlite

<add key="databaseType" value="SQLite" />

<add key="xpoConnectionString" value="XpoProvider=MonoLite;uri=file:{0}.db" />

Notes Dont forget to change user id, password according your needs.