added connection string for local connections
added Linq to using in RoomService