From what I know, SQLCEDataAdapter has performance issue, it drains the memory fast. since you are using sql CE 3.0, why don't you use SqlCeResultSet Class . Here's a another post on MSDN.