Build 1.3.0.7

Rating:        Based on 2 ratings
Reviewed:  1 review
Downloads: 4995
Change Set: e5407afe62d0
Released: Jan 23, 2012
Updated: Feb 14, 2012 by christianhelle
Dev status: Beta Help Icon

Recommended Download

Application SQL Compact Code Generator Stand Alone Application
application, 5086K, uploaded Jan 23, 2012 - 3333 downloads

Other Available Downloads

Application SQL Compact Code Generator Installer (Includes Custom Tools)
application, 4817K, uploaded Jan 23, 2012 - 840 downloads
Example Visual Studio 2010 Samples
example, 1605K, uploaded Nov 15, 2011 - 560 downloads
Example Visual Studio 2008 Samples
example, 119K, uploaded Nov 15, 2011 - 262 downloads

Release Notes

New release of SQL CE Code Generator

New features for this build:
  • Windows Phone 7 "Mango" support for generating a LINQ to SQL DataContext
  • Windows Phone 7 "Mango" Column Indexes
  • Windows Phone 7 "Mango" Entity Ref Associations
  • Windows Phone 7 "Mango" Entity Set Associations
  • Windows Phone 7 "Mango" Version column
  • SQL Compact Edition version 4.0 Support
  • Multiple test framework code generating (MSTest, NUnit, xUnit)
  • Transaction support per DataRepository instance (Begin, Commit, Rollback)
  • Code generation options to enable/disable unit test code generation
  • Display table data
  • Generate mock data access code
  • Export generated code to files containing one class each

Features:
  • Visual Studio 2008 and 2010 Custom Tool Support
  • Generates .NET Compact and Full Framework compatible code
  • Creates entity classes for each table in the database
  • Generates data access code that implements the Repository Pattern
  • Generates methods for Create, Read, Update and Delete operations
  • Generates SelectBy methods for every column in every table
  • Generates a Purge method for every table to delete all records
  • Generates Count() method for retrieving the number of records in each table
  • Generates CreateDatabase() method for re-creating the database
  • Generates xml-doc code comments for entities and data access methods
  • Generates Entity Unit Tests
  • Generates Data Access Unit Tests
  • Generates Mock Data Access code

Data Access Custom Tools:
  • SQLCECodeGenerator - Generates entity and data access components using a single file.
  • SQLCEMangoCodeGenerator - Generates Windows Phone 7 "Mango" SQLCE entity and data access components using a single file
  • SQLCECodeGeneratorV2 - Generates entity and data access components using several files. One file per class or interface
  • SQLCEMangoCodeGeneratorV2 - Generates Windows Phone 7 "Mango" SQLCE entity and data access components using several files. One file per class or interface

Data Access Unit Test Custom Tools:
  • SQLCEMSTestCodeGenerator - Generates entity and data access unit test code that targets MSTest using a single file
  • SQLCENUnitCodeGenerator - Generates entity and data access unit test code that targets NUnit using a single file
  • SQLCEXUnitCodeGenerator - Generates entity and data access unit test code that targets xUnit.net using a single file
  • SQLCEMSTestCodeGeneratorV2 - Generates entity and data access unit test code that targets MSTest using several files. One file per class or interface
  • SQLCENUnitCodeGeneratorV2 - Generates entity and data access unit test code that targets NUnit using several files. One file per class or interface
  • SQLCEXUnitCodeGeneratorV2 - Generates entity and data access unit test code that targets xUnit.net using several files. One file per class or interface

Write the name of the custom tool you wish to use in the Custom Tool field in the Properties Window of an SDF file included in your project, this should create a code-behind file for the generated data access code

Reviews for this release

     
Awesome tool. I was looking for autogenerating context and entities for a windows phone 7 project and I stumbled upon this project on Nuget. Does just what I want and much more. I wonder why Microsoft did not provide built in support for WIndows phone 7 when they started supporting SQL Compact. Only one suggestion, if we can get the entity pluralization support, it will be awesome :) Great job.
by shree_kotekar on Aug 13, 2012 at 1:21 AM