none
Connection to sql 2000 sample and methode ? RRS feed

  • Question

  • Greetings, we have a desktop with sql server 2000 engine application, as we can't connect to sql 2000, inserting records edit delete from LS if anyone has an example or some manual greatly appreciate

     

    Saludos nosotros tenemos una aplicación de escritorio con motor sql server 2000 , como podemos conectarnos a sql 2000 , insertar registros editar eliminar desde LS si alguien tiene un ejemplo o algún manual agradecería mucho 

    Tuesday, September 6, 2011 8:16 PM

Answers

  • If you really need to connect to 2000 (Just joking)... I would use a Custom RIA Service to get this done as you will need to change some of the data types. From what I have read the Entity Framework uses the varchar(max) and such data types and sql 2000 does not have these.
    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    Tuesday, September 6, 2011 10:58 PM
  • As the default SQL Connection and system inside use the Entity framework we are guided by that and as SQL Server 2000 is considered an out of mainstream support system no new work would be done with it.

    Looking at the SQL Client for Entity Framework there is a big note on the page. (http://msdn.microsoft.com/en-us/library/bb896309.aspx)

    "Starting with Visual Studio 2010, the Entity Data Model Tools do not support SQL Server 2000."

    Also

    "SqlClient can be used as a data provider for different versions of SQL Server. These versions have different capabilities. For example, SQL Server 2000 does not support varchar(max) and nvarchar(max) types that were introduced with SQL Server 2005."

    I would also look here... http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/47d73f2d-65a7-4e6d-8a03-747280c1f829

    My only thought is that you will need to create a custom datasource or use RIA Services to connect to the SQL 2000 system. In that you will have to use Normal .Net code and ADO.Net calls to the sql engine and totally bypass the entity framework system.


    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    Wednesday, September 7, 2011 12:39 AM

All replies

  • I would also like something so but to other bd .........!
    Tuesday, September 6, 2011 9:49 PM
  • If you really need to connect to 2000 (Just joking)... I would use a Custom RIA Service to get this done as you will need to change some of the data types. From what I have read the Entity Framework uses the varchar(max) and such data types and sql 2000 does not have these.
    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    Tuesday, September 6, 2011 10:58 PM
  • that I also like to someone LS team for more information or someone to guide you on that path
    Wednesday, September 7, 2011 12:00 AM
  • As the default SQL Connection and system inside use the Entity framework we are guided by that and as SQL Server 2000 is considered an out of mainstream support system no new work would be done with it.

    Looking at the SQL Client for Entity Framework there is a big note on the page. (http://msdn.microsoft.com/en-us/library/bb896309.aspx)

    "Starting with Visual Studio 2010, the Entity Data Model Tools do not support SQL Server 2000."

    Also

    "SqlClient can be used as a data provider for different versions of SQL Server. These versions have different capabilities. For example, SQL Server 2000 does not support varchar(max) and nvarchar(max) types that were introduced with SQL Server 2005."

    I would also look here... http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/47d73f2d-65a7-4e6d-8a03-747280c1f829

    My only thought is that you will need to create a custom datasource or use RIA Services to connect to the SQL 2000 system. In that you will have to use Normal .Net code and ADO.Net calls to the sql engine and totally bypass the entity framework system.


    http://www.virtualrealm.com.au - XNA Game Programming News and Resources from Downunder.
    Wednesday, September 7, 2011 12:39 AM
  • There is the constraint that is why the question serious team of LS to see options do not believe that connect to sql 2000 if not dbf from paradox as for example
    Wednesday, September 7, 2011 12:49 AM
  • or is could make a kind of replication or massive insert from LS bone to create the tables that will be used, same fields to sql serer 2000 and when record tmabein record in sql 2000 using an insert or something
    Wednesday, September 7, 2011 5:19 PM
  • Hi

    Maybe the article bellow help:

    Creating a Simple LightSwitch RIA Service (using POCO)


    Jaime
    Wednesday, September 7, 2011 5:30 PM
  • If you can create a REST or SOAP web service that exposes data from the database, then Silverlight can access that service with its networking stack.
    Thursday, September 8, 2011 4:39 PM