title: Bulk Insert In SQL Server CE
body: <p>i am new at SQL Server CE and using Visual Studio 2008, SQL Server CE 3.5. I want to know that what the best way of inserting bulk records into SQL Server CE database? Does <code>BULK INSERT</code> statement work for SQL Server CE? I have nearly 45 tables and some of these tables should have large amount of data. Using <code>command.Prepare</code> is enough or is there more efficient and fast way?</p>