Consultar lista con linq

            var v = new List<Dato>();
            v.Add(new Dato(1, "carlos"));
            v.Add(new Dato(2, "abc"));


            var qry = from p in v
                        where p._ci == 2
                        select p;
            if (qry.Count() > 0)
                Console.WriteLine(qry.First()._nombre);

Receptor bluetooth con Arduino y android

Ejemplo de door lock (con codigo C# y para Android)

http://www.instructables.com/id/Easy-Bluetooth-Enabled-Door-Lock-With-Arduino-An/



Para conocer la MAC address del dispositivo bluetooth, acceder con alguna aplicación para Android (ej, Bluetooth SPP)
Ej: 
linvor (rssi:-55dBM)
00:12:08:24:01:61
Class:1f00 Bind:Bonded


Instrucciones:

Features:
1) Wireless serial bluetooth port.
2) With free power adapter bottom board come with well power regulator.
User can connect 3.3 to 5VDC and connect TX and RX to your control IO (general 3.3 to 5V digital input output of MCU or arduino IO is ok, or general TLL IO)
3) Easy to connect this module with PC, just search and key "1234" passcode.
4) With white SMD LED on the adapter board, can see the Bluetooth connection status.
 
Step to connect:
1) Connect the wiring, power up, while the device is not connected, the bluetooth module board has a white LED flashing
2) At PC side, search bluetooth device.
3) Found name called "LINVOR" device
4) Connect it, and passcode is "1234"
5) While connection is ok, you can see the LED become always on.
6) Enjoy
 
Basically, user can only use 2 to 5 pin in most of the application
PINNAMEFUNCTION
1KEYFor configuration use (normally not connected)
2VCC3.3 to 5V input
3GNDGround
4TXDTX transmit pin
5RXDRX receive pin
6STATE Connection status
   
Industrial serial port bluetooth, Drop-in replacement for wired serial connections, transparent usage. You can use it
simply for a serial port replacement to establish connection between MCU and GPS, PC to your embedded project and etc.

 

Migrar mantis a nueva version de MySql


Exportar BD 
mysqldump -P 3360 -h Xmantis -uroot -ppasdfsewr234w0rd mantis > mantis.sql

Importar BD
mysql -P 3306 -h localhost -uroot -proot mantisPrueba < mantis.sql

Transformar passwords al nuevo formato
UPDATE mysql.user SET Password = OLD_PASSWORD('root')
WHERE Host = 'localhost' AND User = 'root';

FLUSH PRIVILEGES;

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('root');