Developing Applications with Entity Framework 4.1 training

Duration:
Cost:
$325.00
Hours:
- Eastern

Course Overview

The course starts with an introduction to Entity Framework, where you will learn about data access and object-relational mapping, how the Entity Framework works and the tools it provides, and you will see how to build an entity data model. Then you will explore the entity data model in more detail, where you will learn about the model designer and the raw XML that actually defines the conceptual, storage, and mapping models. You will also learn how you can use stored procedures and functions with Entity Framework. Next you will learn about the most important ways to query data using Entity Framework objects. You are most likely to use LINQ to Entities, but other options include Entity SQL and an Entity Client API. After that, you will learn about the ways that you can modify and customize the entity data objects, using the model designer, partial classes and methods, and events. Finally, you will learn about code-first development, which we are confident is going to become the primary way to develop new Entity Framework applications.

Live Online Schedule

Dec 21
Register
Jan 12
Register
Feb 16
Register
Mar 12
Register

Tap here to learn how our online classes work.

Live Onsite Training

Do you have five (5) or more people needing this class and want us to deliver it at your location?

Prerequisites

This course assumes you are familiar with the Entity Framework and using Visual Studio 2010 or higher.

Course Outline

Developing Applications with Entity Framework 4.1

  • Introduction
    • Prerequisites
    • Installing the Practice Files
      • Software Requirements
      • Sample Database
      • The Chapter Files
  • Introducing the Entity Framework
    • Object-Relational Mapping (ORM) and Data Access
      • Object/Relational Differences
      • Object-Relational Mapping (ORM)
      • Generic Data Objects vs. Entity Objects
      • Data Programming Against a Model
  • The Entity Framework and Data Model
    • Why Use Entity Framework?
    • When Should You Not Use Entity Framework or an ORM?
  • Building a Simple Application Using Entity Framework
    • Building the Entity Data Model and Objects
    • Exploring the New Entity Object Project
  • Entity Framework APIs and Tools
    • Entity Data Model Designer
    • Object Services
    • Entity Framework Services
  • The Entity Data Model
    • Introduction
      • The Models within the Model
  • Creating and Using an Entity Data Model
    • Creating a Model Using Database-First Design
    • Creating a Model Using Model-First Design
    • Explore the Model with the Model Browser
  • Entity Data Model in the Raw
    • The Designer Section
    • The Runtime Section
    • Model Build Mechanics
  • Using Stored Procedures in the Model
    • Updating the Model from the Database
    • Using Stored Procedures for an Entity's Insert, Update, and Delete Functions
    • Using Stored Procedures that Read Data
    • Using Stored Procedures the Return a Scalar Value
  • Lab 2: The Entity Data Model
    • Lab 2 Overview
    • Create a New Model from a Database
    • Update a Database to Include Stored Procedures
    • Use a Stored Procedure to Read Data
  • Querying and Updating Entity Framework Data
    • Overview of Querying Options
      • Entity Framework Query Options
      • Building and Testing Queries with LINQPad
      • A Very Simple Query
  • Using a LINQ to Entities
    • A LINQ Primer
    • LINQ to Entities
    • Projections
    • Querying Related Data
    • Grouping
  • Other Querying Options
    • Querying with Entity SQL
    • Directly Querying EntityClient
  • Updating Entities and Saving Data
    • Updating Existing Entities
    • Inserting New Entities
    • Deleting Entities
  • Lab 3: Querying and Updating Entity Framework Data
    • Lab 3 Overview
    • LINQ to Entities Puzzles
    • Build an Application Using LINQ to Entities
  • Customizing Entities
    • Unleash the Power of Object Relational Mapping
      • The Sample AWLT Model
  • Modifying Entities in the Model Designer
    • Organizing the Model
    • Cleaning Up the Model
    • Default Values
  • Using Partial Classes and Methods to Customize Entities
    • Partial Classes in Entity Framework
  • Hooking into Entity Framework Events
    • ObjectContext's ObjectMaterialized Event
    • ObjectContext's SavingChanges Event
    • EntityObject's PropertyChanging and PropertyChanged Events
    • RelatedEnd's AssociationChanged Event
  • Lab 4: Customizing Entities
    • Lab 4 Overview
    • Build and Organize an Entity Data Model
    • Customize an Entity Data Model
  • Code-First Development
    • Domain-Centric Modeling
      • Using Code-First
  • Creating and Using a Model with Code-First
    • Build an MVC 3 Application and Data Model
    • Using the Model in an MVC 3 Application
  • Customizing the Database
    • Conventions
    • Data Annotations
    • DbModeBuilder API
  • Lab 5: Code-First Development
    • Lab 5 Overview
    • Create a Data Model for Code-First
    • Build a Code-First Database and Explore Its Schema
    • Customize a Code-First Database

Where We Have Trained

We've provided training all over North America and beyond!

Aberdeen, MD Aberdeen, SD Aberdeen, WA Abilene, TX Acton, MA Acworth, GA Ada, OK Addison, IL Adelanto, CA Adrian, MI Agawam, MA Aiken, SC Akron, OH Alabaster, AL Alameda, CA Alamogordo, NM Albany, GA Albany, NY Albany, OR Albert Lea, MN Albertville, AL Albuquerque, NM Alexandria, LA Alexandria, VA Algonquin, IL Alhambra, CA Aliso Viejo, CA Allen, TX Allen Park, MI Allendale, MI Allentown, PA Alliance, NE Alliance, OH Alpharetta, GA Altamonte Springs, FL Alton, IL Altoona, IA Altoona, PA Altus, OK Amarillo, TX American Fork, UT Ames, IA Amesbury, MA Amherst, MA Amherst, NH Amsterdam, NY Anaconda, MT Anacortes, WA Anaheim, CA Anchorage, AK Anderson, IN Anderson, SC Andover, MA Andover, MN Ankeny, IA Ann Arbor, MI Annapolis, MD Anniston, AL Anoka, MN Ansonia, CT Antioch, CA Apache Junction, AZ Apex, NC Apopka, FL Apple Valley, CA Apple Valley, MN Appleton, WI Arcadia, CA Ardmore, OK Arlington, MA Arlington, TX Arlington, WA Arlington Heights, IL Arnold, MO Artesia, NM Arvada, CO Asheboro, NC Asheville, NC Ashland, KY Ashland, MA Ashland, OH Ashland, OR Ashtabula, OH Aspen, CO Atascosa, TX Athens, AL Athens, GA Athens, OH Athens, TN Atlanta, GA Atlantic City, NJ Attleboro, MA Auburn, AL Auburn, IN Auburn, MA Auburn, ME Auburn, NY Auburn, WA Auburn Hills, MI Augusta, GA Augusta, ME Aurora, CO Aurora, IL Aurora, OH Austin, MN Austin, TX Avon, OH Avon Lake, OH Avondale, AZ Avondale Estates, GA Azusa, CA Badger, AK Bainbridge Island, WA Bakersfield, CA Baldwin Park, CA Ballwin, MO Baltimore, MD Bangor, ME Banning, CA Barberton, OH Bardstown, KY Barnegat, NJ Barnstable, MA Barre, VT Barrington, RI Bartlesville, OK Bartlett, IL Bartlett, TN Bartow, FL Batavia, IL Batavia, NY Bath, ME Baton Rouge, LA Battle Creek, MI Battle Ground, WA Bay City, MI Bay Village, OH Bayonne, NJ Bayou Cane, LA Baytown, TX Beacon, NY Beatrice, NE Beaufort, SC Beaumont, CA Beaumont, TX Beaver Dam, WI Beaverton, OR Beckley, WV Bedford, IN Bedford, NH Beech Grove, IN Belgrade, MT Bell Gardens, CA Bella Vista, AR Belle Fourche, SD Belle Glade, FL Belleville, IL Belleville, NJ Bellevue, NE Bellevue, WA Bellflower, CA Bellingham, MA Bellingham, WA Belmont, MA Beloit, WI Belton, MO Belvidere, IL Bend, OR Benton, AR Bentonville, AR Berea, KY Berea, OH Bergenfield, NJ Berkeley, CA Berkeley Heights, NJ Bernardsville, NJ Berwyn, IL Bessemer, AL Bethany, OK Bethel, AK Bethlehem, PA Bettendorf, IA Beulah, ND Beverly, MA Beverly Hills, CA Biddeford, ME Billerica, MA Billings, MT Biloxi, MS Binghamton, NY Birmingham, AL Birmingham, MI Bismarck, ND Bixby, OK Blaine, MN Bloomfield, NJ Bloomfield Hills, MI Bloomington, IL Bloomington, IN Bloomington, MN Blue Springs, MO Bluefield, WV Bluffton, SC Boca Raton, FL Boise, ID Bolingbrook, IL Bonita Springs, FL Bonney Lake, WA Bossier City, LA Boston, MA Bothell, WA Boulder, CO Boulder City, NV Bountiful, UT Bourne, MA Bowie, MD Bowling Green, KY Bowling Green, OH Box Elder, SD Boynton Beach, FL Bozeman, MT Bradenton, FL Braintree, MA Brandon, MS Brandon, SD Brea, CA Brecksville, OH Bremerton, WA Brentwood, CA Brentwood, TN Brewer, ME Brick, NJ Bridgeport, CT Bridgeport, WV Bridgeton, NJ Bridgewater, MA Bridgewater, NJ Brigham City, UT Brighton, CO Brighton, MI Bristol, CT Bristol, RI Bristol, TN Bristol, VA Broadview Heights, OH Brockton, MA Broken Arrow, OK Brookfield, CT Brookfield, WI Brookhaven, MS Brookings, SD Brookline, MA Brooklyn Center, MN Brooklyn Park, MN Brookpark, OH Broomfield, CO Brownsville, TX Brunswick, OH Bryan, TX Buckhead, GA Buena Park, CA Buena Vista, VA Buffalo, MN Buffalo, NY Buffalo Grove, IL Bullhead City, AZ Burbank, CA Burbank, IL Burien, WA Burlington, IA Burlington, MA Burlington, NC Burlington, NJ Burlington, VT Burnsville, MN Burton, MI Butte, MT Byram, MS Byron, MI Cabot, AR Caldwell, ID Calexico, CA Calhoun, GA Calumet City, IL Camarillo, CA Camas, WA Cambridge, MA Cambridge, MD Camden, NJ Campbell, CA Canby, OR Canon City, CO Canton, GA Canton, MA Canton, MI Canton, MS Canton, OH Cape Coral, FL Cape Girardeau, MO Carbondale, IL Caribou, ME Carlsbad, CA Carlsbad, NM Carmel, IN Carol Stream, IL Carpentersville, IL Carrollton, GA Carrollton, TX Carson, CA Carson City, NV Carteret, NJ Cartersville, GA Cary, NC Casa Grande, AZ Casper, WY Casselberry, FL Castle Rock, CO Cathedral City, CA Cayce, SC Cedar City, UT Cedar Falls, IA Cedar Park, TX Cedar Rapids, IA Centerville, OH Centerville, UT Central Falls, RI Central Point, OR Centralia, WA Ceres, CA Cerritos, CA Chalmette, LA Champaign, IL Champlin, MN Chandler, AZ Chanhassen, MN Chaparral, NM Chapel Hill, NC Charleston, SC Charleston, WV Charlotte, NC Charlottesville, VA Chaska, MN Chattanooga, TN Chelmsford, MA Chelsea, MA Chena Ridge, AK Cherry Hill, NJ Chesapeake, VA Chester, PA Chesterfield, MO Cheyenne, WY Chicago, IL Chicago Heights, IL Chickasha, OK Chico, CA Chicopee, MA Chillicothe, OH Chino, CA Chino Hills, CA Chula Vista, CA Cicero, IL Cincinnati, OH Citrus Heights, CA Claremont, CA Claremont, NH Claremore, OK Clarksburg, WV Clarksdale, MS Clarksville, TN Clearfield, UT Clearwater, FL Clemson, SC Clermont, FL Cleveland, MS Cleveland, OH Cleveland, TN Cleveland Heights, OH Cliffside Park, NJ Clifton, NJ Clinton, IA Clinton, MI Clinton, MS Clinton, UT Clive, IA Clovis, CA Clovis, NM Coachella, CA Cocoa, FL Coconut Creek, FL Coeur D Alene, ID Cohoes, NY College, AK College Park, MD College Station, TX Collierville, TN Collinsville, IL Colonial Heights, VA Colorado Springs, CO Colton, CA Columbia, MO Columbia, SC Columbia, TN Columbia Heights, MN Columbus, GA Columbus, IN Columbus, MS Columbus, NE Columbus, OH Commerce City, CO Commerce Township, MI Compton, CA Concord, CA Concord, MA Concord, NC Concord, NH Connersville, IN Conroe, TX Conway, AR Conway, SC Cookeville, TN Coon Rapids, MN Cooper City, FL Coos Bay, OR Coral Gables, FL Coral Springs, FL Coralville, IA Corinth, MS Cornelius, NC Corona, CA Corpus Christi, TX Cortland, NY Corvallis, OR Costa Mesa, CA Cottage Grove, MN Cottonwood Heights, UT Council Bluffs, IA Coventry, RI Covina, CA Covington, GA Covington, KY Covington, VA Covington, WA Cranford, NJ Cranston, RI Crawfordsville, IN Crestview, FL Creve Coeur, MO Crown Point, IN Crystal, MN Crystal Lake, IL Cudahy, WI Culver City, CA Cumberland, MD Cumberland, RI Cupertino, CA Cutler Bay, FL Cuyahoga Falls, OH Cypress, CA Dallas, OR Dallas, TX Dalton, GA Daly City, CA Dana Point, CA Danbury, CT Dania, FL Danvers, MA Danville, CA Danville, IL Danville, KY Danville, VA Daphne, AL Dartmouth, MA Davenport, IA Davie, FL Davis, CA Davison, MI Dayton, OH Daytona Beach, FL De Pere, WI Dearborn, MI Dearborn Heights, MI Decatur, AL Decatur, GA Decatur, IL Dedham, MA Defiance, OH Dekalb, IL Deland, FL Delano, CA Delaware, OH Delray Beach, FL Deltona, FL Deming, NM Denton, TX Denver, CO Derby, CT Derby, KS Derry, NH Des Moines, IA Des Moines, WA Des Plaines, IL Desoto, TX Detroit, MI Devils Lake, ND Diamond Bar, CA Dickinson, ND Dodge City, KS Doral, FL Dothan, AL Douglasville, GA Dover, DE Dover, NH Dowagiac, MI Downers Grove, IL Downey, CA Dracut, MA Draper, UT Dublin, CA Dublin, OH Dubuque, IA Duluth, GA Duluth, MN Dunbar, WV Duncan, OK Dunedin, FL Dunwoody, GA Durango, CO Durant, OK Durham, NC Durham, NH Dyersburg, TN Eagan, MN Eagle, ID Eagle Mountain, UT Easley, SC East Brunswick, NJ East Chicago, IN East Cleveland, OH East Lansing, MI East Orange, NJ East Providence, RI East Ridge, TN East Saint Louis, IL Easthampton, MA Eastlake, OH Easton, MA Easton, PA Eastpointe, MI Eau Claire, WI Eden Prairie, MN Edina, MN Edinburg, TX Edison, NJ Edmond, OK Edmonds, WA Edwardsville, IL Egg Harbor Township, NJ El Cajon, CA El Centro, CA El Dorado, KS El Mirage, AZ El Monte, CA El Paso, TX El Reno, OK Eldorado, TX Elgin, IL Elizabeth, NJ Elizabethton, TN Elizabethtown, KY Elk Grove, CA Elk Grove Village, IL Elk River, MN Elkhart, IN Elko, NV Ellensburg, WA Elmhurst, IL Elmira, NY Elmwood Park, IL Elyria, OH Emporia, KS Emporia, VA Encinitas, CA Englewood, CO Englewood, NJ Enid, OK Enterprise, AL Erie, CO Erie, PA Erlanger, KY Escondido, CA Euclid, OH Eugene, OR Euless, TX Evans, CO Evans, GA Evanston, IL Evanston, WY Evansville, IN Everett, MA Everett, WA Ewa Beach, HI Ewa Gentry, HI Exeter, NH Fair Lawn, NJ Fairbanks, AK Fairborn, OH Fairfax, VA Fairfield, CA Fairfield, OH Fairmont, WV Fairview Park, OH Fall River, MA Fallon, NV Falls Church, VA Falmouth, MA Fargo, ND Faribault, MN Farmington, MI Farmington, MN Farmington, MO Farmington, NM Farmington, UT Farragut, TN Fayetteville, AR Fayetteville, GA Fayetteville, NC Federal Way, WA Fenton, MI Ferndale, MI Fernley, NV Findlay, OH Fitchburg, MA Fitchburg, WI Flagstaff, AZ Flint, MI Florence, AL Florence, AZ Florence, KY Florence, SC Florissant, MO Flower Mound, TX Flushing, MI Folsom, CA Fond Du Lac, WI Fontana, CA Forest Grove, OR Forest Hills, MI Forest Lake, MN Forest Park, OH Fort Benning, GA Fort Collins, CO Fort Dodge, IA Fort Lauderdale, FL Fort Lee, NJ Fort Mill, SC Fort Myers, FL Fort Pierce, FL Fort Smith, AR Fort Thomas, KY Fort Walton Beach, FL Fort Wayne, IN Fort Worth, TX Fountain, CO Fountain Hills, AZ Fountain Valley, CA Foxboro, MA Framingham, MA Frankfort, IN Frankfort, KY Franklin, IN Franklin, MA Franklin, NJ Franklin, TN Franklin, VA Franklin, WI Frederick, MD Fredericksburg, VA Freehold, NJ Freeport, IL Fremont, CA Fremont, NE Fremont, OH Fresno, CA Fridley, MN Frisco, TX Fruita, CO Fullerton, CA Gadsden, AL Gaffney, SC Gahanna, OH Gaines, MI Gainesville, FL Gainesville, GA Gaithersburg, MD Galax, VA Galesburg, IL Gallatin, TN Gallup, NM Garden City, KS Garden City, MI Garden Grove, CA Gardena, CA Gardner, KS Gardner, MA Garfield, NJ Garfield Heights, OH Garland, TX Garner, NC Gary, IN Gastonia, NC Gautier, MS Georgetown, DE Georgetown, KY Georgetown, TX Gering, NE Germantown, TN Gilbert, AZ Gillette, WY Gilroy, CA Glasgow, KY Glen Cove, NY Glen Ellyn, IL Glen Falls, NY Glendale, AZ Glendale, CA Glendale Heights, IL Glendora, CA Glenview, IL Glenwood Springs, CO Gloucester, MA Gloucester City, NJ Gloversville, NY Goffstown, NH Golden, CO Golden Valley, MN Goldsboro, NC Goleta, CA Goodlettsville, TN Goodyear, AZ Goose Creek, SC Goshen, IN Grafton, MA Grafton, ND Grand Blanc, MI Grand Forks, ND Grand Haven, MI Grand Island, NE Grand Junction, CO Grand Prairie, TX Grand Rapids, MI Grandview, MO Grandville, MI Granite City, IL Grants Pass, OR Great Bend, KS Great Falls, MT Greeley, CO Green Bay, WI Green River, WY Greenacres, FL Greenbelt, MD Greencastle, IN Greeneville, TN Greenfield, IN Greenfield, MA Greenfield, WI Greensboro, NC Greensburg, IN Greensburg, PA Greenville, MI Greenville, MS Greenville, NC Greenville, SC Greenwood, IN Greenwood, MS Greenwood, SC Greer, SC Grenada, MS Gresham, OR Gretna, LA Griffin, GA Grosse Ile, MI Grosse Pointe, MI Groton, CT Grove City, OH Gulfport, MS Gurnee, IL Hackensack, NJ Hagerstown, MD Haines City, FL Halawa, HI Hallandale, FL Ham Lake, MN Hamilton, NJ Hamilton, OH Hammond, IN Hammond, LA Hampton, CT Hampton, NH Hampton, VA Hamtramck, MI Hanahan, SC Hanford, CA Hannibal, MO Hanover, NH Happy Valley, OR Harlingen, TX Harrisburg, PA Harrison, MI Harrison Township, MI Harrisonburg, VA Hartford, CT Hartford, WI Harvey, IL Harvey, LA Haslett, MI Hastings, MN Hastings, NE Hattiesburg, MS Havelock, NC Haverhill, MA Havre, MT Havre De Grace, MD Hawthorne, CA Hays, KS Hayward, CA Hazel Park, MI Hazelwood, MO Hazlet, NJ Hazleton, PA Helena, MT Hemet, CA Henderson, KY Henderson, NV Hendersonville, TN Hermiston, OR Hermitage, PA Hernando, MS Herriman, UT Hesperia, CA Hialeah, FL Hibbing, MN Hickory, NC High Point, NC Highland, CA Highland, MI Highland, UT Highland Park, IL Highland Park, MI Hilliard, OH Hillsboro, OR Hillsborough, NJ Hillside, NJ Hilo, HI Hilton Head Island, SC Hinesville, GA Hingham, MA Hobart, IN Hobbs, NM Hoboken, NJ Hoffman Estates, IL Holden, MA Holladay, UT Holland, MI Hollister, CA Holly Springs, NC Hollywood, FL Holt, MI Holyoke, MA Homer Glen, IL Homestead, FL Honolulu, HI Hooksett, NH Hoover, AL Hopewell, VA Hopkins, MN Hopkinsville, KY Horn Lake, MS Hot Springs Village, AR Houma, LA Houston, TX Howell, NJ Huber Heights, OH Hudson, MA Hudson, NH Hudson, OH Huntersville, NC Huntington, IN Huntington, WV Huntington Beach, CA Huntington Park, CA Huntley, IL Huntsville, AL Huron, SD Hurricane, UT Hutchinson, KS Hutchinson, MN Hyattsville, MD Idaho Falls, ID Independence, KY Independence, MO Indian Trail, NC Indianapolis, IN Indianola, IA Indio, CA Inglewood, CA Inkster, MI Inver Grove Heights, MN Iowa City, IA Irmo, SC Irvine, CA Irving, TX Irvington, NJ Issaquah, WA Ithaca, NY Jackson, MI Jackson, MS Jackson, NJ Jackson, TN Jackson, WY Jacksonville, AR Jacksonville, FL Jacksonville, NC Jacksonville Beach, FL Jamestown, ND Jamestown, NY Janesville, WI Jasper, IN Jefferson City, MO Jeffersonville, IN Jeffersonville, KY Jenison, MI Jenks, OK Jersey City, NJ Johns Creek, GA Johnson City, TN Johnston, IA Johnston, RI Johnstown, PA Joliet, IL Jonesboro, AR Joplin, MO Junction City, KS Juneau, AK Jupiter, FL Kahului, HI Kailua, HI Kalamazoo, MI Kalifornsky, AK Kalispell, MT Kaneohe, HI Kankakee, IL Kannapolis, NC Kansas City, KS Kansas City, MO Kapolei, HI Kaukauna, WI Kaysville, UT Kearney, NE Kearny, NJ Keene, NH Keizer, OR Kenai, AK Kenmore, WA Kenner, LA Kennesaw, GA Kennewick, WA Kenosha, WI Kent, OH Kent, WA Kernersville, NC Ketchikan, AK Kettering, OH Key West, FL Kihei, HI Killeen, TX Kingman, AZ Kingsport, TN Kingston, NY Kinston, NC Kirkland, WA Kirksville, MO Kissimmee, FL Klamath Falls, OR Knik-Fairview, AK Knoxville, TN Kodiak, AK Kokomo, IN Kuna, ID La Crosse, WI La Grande, OR La Habra, CA La Mesa, CA La Mirada, CA La Place, LA La Porte, IN La Puente, CA La Quinta, CA La Vergne, TN La Verne, CA La Vista, NE Lacey, WA Lackawanna, NY Laconia, NH Lafayette, CO Lafayette, IN Lafayette, LA Lagrange, GA Laguna Hills, CA Laguna Niguel, CA Lake Charles, LA Lake Elsinore, CA Lake Forest, CA Lake Havasu City, AZ Lake In The Hills, IL Lake Oswego, OR Lake Saint Louis, MO Lake Station, IN Lake Stevens, WA Lake Worth, FL Lakeland, FL Lakeville, MN Lakewood, CA Lakewood, NJ Lakewood, OH Lakewood, WA Lancaster, CA Lancaster, OH Lancaster, PA Lansing, IL Lansing, MI Lapeer, MI Laramie, WY Laredo, TX Largo, FL Las Cruces, NM Las Vegas, NM Las Vegas, NV Lauderhill, FL Laurel, MD Laurel, MS Laurel, MT Lawndale, CA Lawrence, IN Lawrence, KS Lawrence, MA Lawrence Township, NJ Lawrenceville, GA Lawton, OK Layton, UT League City, TX Leavenworth, KS Leawood, KS Lebanon, IN Lebanon, MO Lebanon, NH Lebanon, OH Lebanon, OR Lebanon, PA Lebanon, TN Lees Summit, MO Leesburg, FL Lehi, UT Lenexa, KS Leominster, MA Lewiston, ID Lewiston, ME Lewistown, MT Lewisville, TX Lexington, KY Lexington, MA Lexington, NE Lexington, SC Lexington, VA Liberal, KS Liberty, MO Lima, OH Lincoln, CA Lincoln, NE Lincoln, RI Lincoln Park, MI Linden, NJ Lino Lakes, MN Lithia Springs, GA Little Rock, AR Littleton, CO Livermore, CA Livingston, MT Livingston, NJ Livonia, MI Lockport, IL Lockport, NY Lodi, CA Lodi, NJ Logan, UT Logansport, IN Lombard, IL Lompoc, CA Londonderry, NH Long Beach, CA Long Beach, MS Long Beach, NY Long Branch, NJ Longmont, CO Longview, TX Longview, WA Lookout Mountain, GA Lorain, OH Los Alamos, NM Los Angeles, CA Los Banos, CA Los Gatos, CA Los Lunas, NM Louisville, CO Louisville, KY Loveland, CO Lovington, NM Lowell, MA Lowell, MI Lubbock, TX Ludington, MI Ludlow, MA Lumberton, NC Lynchburg, VA Lyndhurst, NJ Lynn, MA Lynn Haven, FL Lynnwood, WA Lynwood, CA Mableton, GA Macomb, MI Macon, GA Madera, CA Madison, AL Madison, IN Madison, MS Madison, SD Madison, WI Madison Heights, MI Madisonville, KY Mahwah, NJ Maitland, FL Makakilo, HI Malden, MA Manassas, VA Manchester, MO Manchester, NH Manchester Township, NJ Mandan, ND Manhattan, KS Manhattan Beach, CA Manistee, MI Manitowoc, WI Mankato, MN Mansfield, MA Mansfield, OH Mansfield, TX Manteca, CA Maple Grove, MN Maple Heights, OH Maple Valley, WA Maplewood, NJ Marana, AZ Margate, FL Maricopa, AZ Marietta, GA Marietta, OH Marion, IA Marion, IN Marion, OH Marlboro, NJ Marlborough, MA Marquette, MI Marrero, LA Marshalltown, IA Marshfield, MA Marshfield, WI Martinez, CA Martinsburg, WV Martinsville, IN Martinsville, VA Maryland Heights, MO Marysville, OH Marysville, WA Maryville, TN Mason, OH Mason City, IA Massillon, OH Matthews, NC Mauldin, SC Maumee, OH Mayfield Heights, OH Mcalester, OK Mcallen, TX Mcdonough, GA Mchenry, IL Mckeesport, PA Mckinney, TX Mcminnville, OR Mcpherson, KS Meadow Lakes, AK Medford, MA Medford, NJ Medford, OR Medina, OH Melbourne, FL Melrose, MA Melrose Park, IL Memphis, TN Menasha, WI Menifee, CA Menlo Park, CA Menomonie, WI Mentor, OH Mequon, WI Merced, CA Mercer Island, WA Meriden, CT Meridian, ID Meridian, MS Merrimack, NH Mesquite, NV Mesquite, TX Metairie, LA Methuen, MA Miami, FL Miami, OK Miami Beach, FL Miami Gardens, FL Miamisburg, OH Michigan City, IN Middleboro, MA Middleburg Heights, OH Middleton, WI Middletown, CT Middletown, DE Middletown, NJ Middletown, NY Middletown, OH Middletown, RI Midland, MI Midland, TX Midvale, UT Midwest City, OK Miles City, MT Milford, CT Milford, DE Milford, MA Milford, MI Milford, NH Mililani, HI Mililani Mauka, HI Mill Creek, WA Millburn, NJ Millville, NJ Milpitas, CA Milton, GA Milton, MA Milwaukee, WI Minneapolis, MN Minnetonka, MN Minot, ND Mint Hill, NC Miramar Beach, FL Mishawaka, IN Mission, TX Mission Viejo, CA Missoula, MT Missouri City, TX Mitchell, SD Mobile, AL Modesto, CA Moline, IL Monroe, LA Monroe, MI Monroe, NC Monroe, WA Monroe Township, NJ Monrovia, CA Montclair, CA Montclair, NJ Montebello, CA Monterey Park, CA Montgomery, AL Monticello, FL Montpelier, VT Montrose, CO Montville, NJ Moore, OK Moore Haven, FL Moorestown, NJ Mooresville, NC Moorhead, MN Moorpark, CA Moreno Valley, CA Morgan Hill, CA Morgantown, WV Morristown, NJ Morristown, TN Moscow, ID Moses Lake, WA Moss Point, MS Moundsville, WV Mount Clemens, MI Mount Laurel, NJ Mount Morris, MI Mount Pleasant, MI Mount Pleasant, SC Mount Prospect, IL Mount Rainier, MD Mount Vernon, NY Mount Vernon, OH Mount Vernon, WA Mountain Brook, AL Mountain Home, ID Mountain View, CA Mountlake Terrace, WA Mukilteo, WA Muncie, IN Mundelein, IL Murfreesboro, TN Murray, KY Murray, UT Murrieta, CA Muscatine, IA Muskego, WI Muskegon, MI Muskogee, OK Mustang, OK Myrtle Beach, SC Nampa, ID Napa, CA Naperville, IL Naples, FL Narragansett, RI Nashua, NH Nashville, TN Natchez, MS Natchitoches, LA Natick, MA National City, CA Needham, MA Neenah, WI Neptune, NJ New Albany, IN New Bedford, MA New Berlin, WI New Bern, NC New Braunfels, TX New Brighton, MN New Britain, CT New Brunswick, NJ New Castle, DE New Castle, IN New Castle, PA New Franklin, OH New Hartford, CT New Haven, CT New Haven, IN New Hope, MN New Iberia, LA New Lenox, IL New London, CT New Orleans, LA New Philadelphia, OH New Rochelle, NY New Smyrna Beach, FL New York, NY Newark, CA Newark, DE Newark, NJ Newark, OH Newberg, OR Newburgh, NY Newburyport, MA Newnan, GA Newport, KY Newport, RI Newport, VT Newport Beach, CA Newport News, VA Newton, IA Newton, KS Newton, MA Niagara Falls, NY Nicholasville, KY Niles, IL Niles, MI Niles, OH Nixa, MO Noblesville, IN Norfolk, CT Norfolk, NE Norfolk, VA Normal, IL Norman, OK North Andover, MA North Attleboro, MA North Augusta, SC North Bergen, NJ North Brunswick, NJ North Canton, OH North Charleston, SC North Chicago, IL North Fort Myers, FL North Haven, CT North Kingstown, RI North Las Vegas, NV North Lauderdale, FL North Little Rock, AR North Miami Beach, FL North Myrtle Beach, SC North Ogden, UT North Olmsted, OH North Platte, NE North Port, FL North Providence, RI North Richland Hills, TX North Ridgeville, OH North Royalton, OH North Salt Lake, UT North Tonawanda, NY Northampton, MA Northbrook, IL Northfield, MN Northport, AL Northville, MI Norton, MA Norton, VA Norwalk, CA Norwalk, CT Norwalk, OH Norwich, CT Norwood, MA Norwood, OH Novato, CA Novi, MI Nutley, NJ O Fallon, IL O Fallon, MO Oak Creek, WI Oak Forest, IL Oak Harbor, WA Oak Lawn, IL Oak Park, IL Oak Park, MI Oak Ridge, TN Oakdale, MN Oakland, CA Oakland, MI Oakland Park, FL Oakley, CA Ocala, FL Ocean City, NJ Ocean Springs, MS Oceanside, CA Ocoee, FL Oconomowoc, WI Odessa, TX Ogden, UT Okemos, MI Oklahoma City, OK Olathe, KS Old Bridge, NJ Olean, NY Olive Branch, MS Olympia, WA Omaha, NE Onalaska, WI Ontario, CA Opelika, AL Opelousas, LA Orange, CA Orange, NJ Orangeburg, SC Oregon, OH Oregon City, OR Orem, UT Orland Park, IL Orlando, FL Ormond Beach, FL Oshkosh, WI Oswego, IL Oswego, NY Ottawa, KS Ottumwa, IA Overland Park, KS Oviedo, FL Owasso, OK Owatonna, MN Owensboro, KY Owosso, MI Oxford, AL Oxford, MI Oxford, MS Oxford, OH Oxnard, CA Ozark, MO Pacifica, CA Paducah, KY Painesville, OH Palatine, IL Palm Bay, FL Palm Beach, FL Palm Beach Gardens, FL Palm Coast, FL Palm Desert, CA Palm Springs, CA Palmdale, CA Palmer, AK Palo Alto, CA Panama City, FL Papillion, NE Paragould, AR Paramount, CA Paramus, NJ Park Ridge, IL Parker, CO Parkersburg, WV Parma, OH Parsippany, NJ Pasadena, CA Pasadena, TX Pascagoula, MS Pasco, WA Paso Robles, CA Passaic, NJ Pataskala, OH Paterson, NJ Pawtucket, RI Payson, UT Peabody, MA Peachtree City, GA Pearl, MS Pearl City, HI Pearland, TX Peekskill, NY Pekin, IL Pelham, AL Pelham, NH Pemberton, NJ Pembroke, MA Pembroke Pines, FL Pendleton, OR Pennsauken, NJ Pensacola, FL Pentwater, MI Peoria, AZ Peoria, IL Perris, CA Perrysburg, OH Perth Amboy, NJ Peru, IN Petaluma, CA Petersburg, VA Pflugerville, TX Pharr, TX Phenix City, AL Philadelphia, PA Phoenix, AZ Pickerington, OH Pico Rivera, CA Pierre, SD Pine Bluff, AR Pinellas Park, FL Piqua, OH Piscataway, NJ Pittsburg, CA Pittsburg, KS Pittsburgh, PA Pittsfield, MA Placentia, CA Plainfield, IL Plainfield, NJ Plainsboro, NJ Plano, TX Plant City, FL Plantation, FL Plattsburgh, NY Pleasant Grove, UT Pleasant Hill, CA Pleasantville, NJ Plymouth, CT Plymouth, IN Plymouth, MA Plymouth, MI Plymouth, MN Pocatello, ID Pomona, CA Pompano Beach, FL Ponca City, OK Pontiac, MI Pooler, GA Poplar Bluff, MO Poquoson, VA Port Angeles, WA Port Arthur, TX Port Huron, MI Port Orange, FL Port Royal, SC Port Saint Lucie, FL Portage, IN Portage, MI Portales, NM Porterville, CA Portland, ME Portland, OR Portsmouth, NH Portsmouth, OH Portsmouth, RI Portsmouth, VA Post Falls, ID Pottsville, PA Poughkeepsie, NY Poway, CA Powder Springs, GA Prairie Village, KS Prairieville, LA Prattville, AL Prescott, AZ Prescott Valley, AZ Presque Isle, ME Prichard, AL Princeton, NJ Prior Lake, MN Prospect, CT Providence, RI Provo, UT Pueblo, CO Pullman, WA Puyallup, WA Queen Creek, AZ Quincy, IL Quincy, MA Racine, WI Radcliff, KY Radford, VA Raleigh, NC Ramsey, MN Ramsey, NJ Rancho Cordova, CA Rancho Palos Verdes, CA Rancho Santa Margarita, CA Randolph, MA Randolph, NJ Rapid City, SD Raritan, NJ Raymore, MO Raytown, MO Reading, MA Reading, PA Red Wing, MN Redan, GA Redding, CA Redford, MI Redlands, CA Redmond, OR Redmond, WA Redondo Beach, CA Redwood City, CA Reno, NV Renton, WA Republic, MO Revere, MA Rexburg, ID Reynoldsburg, OH Rialto, CA Richardson, TX Richfield, MN Richland, WA Richmond, CA Richmond, IN Richmond, KY Richmond, VA Ridgeland, MS Ridgewood, NJ Rio Rancho, NM River Falls, WI Riverside, CA Riverside, CT Riverton, UT Riverton, WY Riviera Beach, FL Roanoke, VA Rochester, MI Rochester, MN Rochester, NH Rochester, NY Rock Hill, SC Rock Island, IL Rock Springs, WY Rockaway, NJ Rockford, IL Rockland, MA Rockledge, FL Rocklin, CA Rockville, MD Rocky Mount, NC Rocky River, OH Rogers, AR Rohnert Park, CA Rolla, MO Rolling Meadows, IL Rome, GA Rome, NY Romeoville, IL Romulus, MI Roseburg, OR Roselle, NJ Rosemead, CA Rosemount, MN Roseville, CA Roseville, MI Roseville, MN Roswell, GA Roswell, NM Round Lake, IL Round Rock, TX Rowlett, TX Roy, UT Royal Kunia, HI Royal Oak, MI Russellville, AR Ruston, LA Rutland, VT Rye, NY Saco, ME Sacramento, CA Saginaw, MI Sahuarita, AZ Saint Albans, VT Saint Albans, WV Saint Charles, IL Saint Charles, MO Saint Clair, MI Saint Clair Shores, MI Saint Cloud, FL Saint Cloud, MN Saint George, UT Saint Helens, OR Saint Joseph, MO Saint Louis, MO Saint Louis Park, MN Saint Michael, MN Saint Paul, MN Saint Peters, MO Saint Petersburg, FL Salem, CT Salem, MA Salem, NH Salem, OR Salem, VA Salina, KS Salinas, CA Salisbury, MD Salisbury, NC Salt Lake City, UT Sammamish, WA San Angelo, TX San Antonio, TX San Bernardino, CA San Bruno, CA San Clemente, CA San Diego, CA San Dimas, CA San Francisco, CA San Gabriel, CA San Jacinto, CA San Jose, CA San Juan Capistrano, CA San Leandro, CA San Luis Obispo, CA San Marcos, CA San Marcos, TX San Mateo, CA San Rafael, CA San Ramon, CA Sand Springs, OK Sandusky, OH Sandwich, MA Sandy, UT Sandy Springs, GA Sanford, FL Sanford, ME Sanford, NC Santa Ana, CA Santa Barbara, CA Santa Clara, CA Santa Clarita, CA Santa Cruz, CA Santa Fe, NM Santa Maria, CA Santa Monica, CA Santa Paula, CA Santa Rosa, CA Santee, CA Sapulpa, OK Sarasota, FL Saratoga, CA Saratoga Springs, NY Saratoga Springs, UT Sartell, MN Saugus, MA Savage, MN Savannah, GA Sayreville, NJ Schaumburg, IL Schenectady, NY Schofield Barracks, HI Scituate, MA Scotch Plains, NJ Scottsbluff, NE Scottsdale, AZ Scottville, MI Scranton, PA Seaford, DE Searcy, AR Seaside, CA SeaTac, WA Seattle, WA Sebastian, FL Sebring, FL Sedalia, MO Selma, AL Seymour, IN Shaker Heights, OH Shakopee, MN Sharon, MA Sharon, PA Shawnee, KS Shawnee, OK Sheboygan, WI Shelby, MI Shelby, NC Shelbyville, IN Shelbyville, KY Shelbyville, MI Shelbyville, TN Shelton, CT Shenandoah, LA Sheridan, WY Sherwood, AR Sherwood, OR Shoreline, WA Shoreview, MN Shreveport, LA Shrewsbury, MA Sidney, MT Sidney, OH Sierra Vista, AZ Sikeston, MO Simi Valley, CA Simpsonville, SC Sioux City, IA Sioux Falls, SD Sitka, AK Skokie, IL Slidell, LA Smithfield, RI Smyrna, DE Smyrna, GA Smyrna, TN Solon, OH Somerset, MA Somersworth, NH Somerville, MA South Bend, IN South Burlington, VT South Euclid, OH South Gate, CA South Hadley, MA South Jordan, UT South Kingstown, RI South Milwaukee, WI South Ogden, UT South Plainfield, NJ South Portland, ME South Saint Paul, MN South Salt Lake, UT South San Francisco, CA South Sioux City, NE South Valley, NM Southaven, MS Southbridge, MA Southfield, MI Southgate, MI Southport, CT Spanish Fork, UT Sparks, NV Sparta, NJ Spartanburg, SC Spearfish, SD Spokane, WA Spokane Valley, WA Spring, TX Springboro, OH Springdale, AR Springfield, IL Springfield, MA Springfield, MO Springfield, OH Springfield, OR Springfield, TN Springville, UT Stamford, CT Stanton, CA Starkville, MS Statesboro, GA Statesville, NC Staunton, VA Steamboat Springs, CO Steele Creek, AK Sterling, AK Sterling, CO Sterling Heights, MI Steubenville, OH Stevens Point, WI Stillwater, MN Stillwater, OK Stockbridge, GA Stockton, CA Stoneham, MA Stoughton, MA Stow, OH Streamwood, IL Streetsboro, OH Strongsville, OH Sturgis, SD Sudbury, MA Suffolk, VA Sugar Land, TX Sulphur, LA Summerville, SC Summit, NJ Sumter, SC Sun Prairie, WI Sunland Park, NM Sunnyside, WA Sunnyvale, CA Sunrise, FL Superior, WI Surprise, AZ Swartz Creek, MI Sylvania, OH Syracuse, NY Syracuse, UT Tacoma, WA Tahlequah, OK Takoma Park, MD Tallahassee, FL Tallmadge, OH Tampa, FL Tanaina, AK Tarpon Springs, FL Taunton, MA Taylor, MI Taylorsville, UT Teaneck, NJ Temecula, CA Tempe, AZ Temple, TX Temple City, CA Terre Haute, IN Terrytown, LA Tewksbury, MA Texarkana, AR The Dalles, OR Thibodaux, LA Thomasville, NC Thornton, CO Thousand Oaks, CA Tiffin, OH Tifton, GA Tigard, OR Tinley Park, IL Tiverton, RI Toledo, OH Toms River, NJ Tonawanda, NY Tooele, UT Topeka, KS Torrance, CA Torrington, CT Tracy, CA Traverse City, MI Trenton, MI Trenton, NJ Troutdale, OR Troy, AL Troy, MI Troy, NY Troy, OH Trussville, AL Tualatin, OR Tucker, GA Tucson, AZ Tukwila, WA Tulare, CA Tullahoma, TN Tulsa, OK Tumwater, WA Tupelo, MS Turlock, CA Tuscaloosa, AL Tustin, CA Twin Falls, ID Twinsburg, OH Tybee Island, GA Tyler, TX Union, NJ Union City, CA Union City, NJ University Place, WA Upland, CA Upper Arlington, OH Urbana, IL Urbandale, IA Utica, NY Vacaville, CA Valdosta, GA Vallejo, CA Valley City, ND Valparaiso, IN Van Buren, AR Vancouver, WA Vandalia, OH Venice, FL Ventura, CA Vergennes, VT Vermillion, SD Vernon, NJ Vernon Hills, IL Vero Beach, FL Vestavia Hills, AL Vicksburg, MS Victoria, TX Victorville, CA Vidalia, GA Vienna, WV Villa Rica, GA Vincennes, IN Vineland, NJ Virginia Beach, VA Visalia, CA Vista, CA Voorhees, NJ Wabash, IN Waco, TX Wadsworth, OH Wahiawa, HI Wahpeton, ND Wailuku, HI Waipahu, HI Wake Forest, NC Wakefield, MA Walla Walla, WA Walnut, CA Walnut Creek, CA Walpole, MA Waltham, MA Wareham, MA Warner Robins, GA Warren, MI Warren, OH Warrensburg, MO Warsaw, IN Warwick, RI Washington, DC Washington, IN Washington, MI Washington, NJ Washington, PA Washington, UT Washington Court House, OH Washougal, WA Wasilla, AK Waterbury, CT Waterford, CT Waterford, MI Waterloo, IA Watertown, MA Watertown, NY Watertown, SD Watertown, WI Waterville, ME Watsonville, CA Waukegan, IL Waukesha, WI Wausau, WI Wauwatosa, WI Waycross, GA Wayne, MI Wayne, NJ Waynesboro, GA Waynesboro, VA Webster, MA Webster Groves, MO Weirton, WV Wellesley, MA Wellington, FL Wenatchee, WA Wentzville, MO West Allis, WI West Bend, WI West Bloomfield, MI West Chicago, IL West Columbia, SC West Covina, CA West Deptford, NJ West Des Moines, IA West Fargo, ND West Haven, CT West Hollywood, CA West Jordan, UT West Lafayette, IN West Linn, OR West Memphis, AR West Milford, NJ West Monroe, LA West New York, NJ West Orange, NJ West Palm Beach, FL West Sacramento, CA West Saint Paul, MN West Springfield, MA West Warwick, RI Westborough, MA Westbrook, ME Westerly, RI Westerville, OH Westfield, IN Westfield, MA Westfield, NJ Westford, MA Westlake, OH Westland, MI Westminster, CA Westminster, CO Westminster, MD Westmont, IL Weston, FL Westport, CT Weymouth, MA Wheat Ridge, CO Wheaton, IL Wheeling, IL Wheeling, WV White Bear Lake, MN White Lake, MI White Plains, NY Whitefish, MT Whitehall, OH Whitewater, WI Whittier, CA Wichita, KS Wichita Falls, TX Wildomar, CA Wildwood, MO Wilkes Barre, PA Williamsburg, VA Williamsport, PA Willingboro, NJ Williston, ND Willmar, MN Willoughby, OH Willowick, OH Wilmette, IL Wilmington, DE Wilmington, MA Wilmington, NC Wilson, NC Wilsonville, OR Winchester, KY Winchester, MA Winchester, VA Windham, NH Windsor, CO Windsor, CT Winfield, KS Winnemucca, NV Winona, MN Winooski, VT Winsted, CT Winston Salem, NC Winter Garden, FL Winter Haven, FL Winter Park, FL Winter Springs, FL Winthrop, MA Wisconsin Rapids, WI Woburn, MA Woodbridge, NJ Woodburn, OR Woodbury, CT Woodbury, MN Woodland, CA Woodridge, IL Woodstock, GA Woodstock, IL Woonsocket, RI Wooster, OH Worcester, MA Worthington, OH Wyandotte, MI Wyoming, MI Xenia, OH Yakima, WA Yankton, SD Yarmouth Port, MA Yonkers, NY Yorba Linda, CA York, PA Youngstown, OH Ypsilanti, MI Yuba City, CA Yucaipa, CA Yukon, OK Yuma, AZ Zachary, LA Zanesville, OH Zephyrhills, FL Zion, IL