Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Zac 39 posts 61 karma points
    Feb 17, 2011 @ 04:16
    Zac
    1

    SQL Compact Support

    Now that Umbraco 4.6.1 supports Sql CE 4.0 it would be great if Tea Commerce did as well. I just tried using Sql CE but it didnt work due to this use of SqlConnection. There were also a few circular DB references that need to be removed. More details here: http://erikej.blogspot.com/2010/07/getting-started-with-sql-server-compact.html

    Thanks

    Copy Link
  • Anders Burla 2560 posts 8256 karma points
    Feb 17, 2011 @ 08:14
    Anders Burla
    0

    Hi Zac

    Thanks for the idea and we will look into it. What I could read from the blog post it's not possible to use LINQ to SQL when using Sql CE 4.0? Do you by chance have exactly what circular references that are in the DB - table and columns?

    Appreciate your help

    Copy Link
  • Zac 39 posts 61 karma points
    Feb 17, 2011 @ 08:21
    Zac
    0

    Not sure about Linq to Sql but as it's no longer being developed I would think you'd be better off with the entity framework anyway. The entity framework definately is supported by Sql CE 4.0

    The constraints I had issues with were:

    - FK_TeaCommerce_Country_PaymentMethodId
    - FK_TeaCommerce_Country_ShippingMethodId

    I'm not sure how much of an issue these really are, but when I tried to convert my Sql Express DB to Sql CE I had to remove them.

    Copy Link
  • Anders Burla 2560 posts 8256 karma points
    Feb 17, 2011 @ 08:40
    Anders Burla
    0

    Thanks for the info. If we need to change from "LINQ to SQL" til Entity Framework it will be a little time before we can do that - but ofcourse we need to support SQL CE as well. I will keep you informed when we have a release with SQL CE support.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft