none
SqLite3 and dotnet core 3.0 Mark J.Price book RRS feed

  • Question

  • I try this at the command line : sqlite3 Northwind.db < Northwind.sql and I receive an error message.

    Reference Mark J.Price book C#8.0 and .Net Core 3.0- Modern cross platform page 469 chapter 14

    Error: L’opérateur « < » est réservé à une utilisation future. (The caracter < is reserved for a future use)


        + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
        + FullyQualifiedErrorId : RedirectionNotSupported

    Tuesday, February 18, 2020 4:27 PM

All replies

  • It seems that you use a command window called “PowerShell”. However, for such SQLite commands you need the classic command prompt. To switch to command prompt, instead of typing sqline3 command, try executing “cmd  /k”. When the prompt line appears, enter your sqlite3 commands.

    Tuesday, February 18, 2020 7:11 PM
  • Hi AlainRousseau6,
    Are you using PowerShell? If so, you can use the pipe operator | like this:

    Get-Content Northwind.sql  | sqlite3 Northwind.db

    And PowerShell does not support "<" operator, you can also try the following command.

    sqlite3 Northwind.db -init Northwind.sql

    Best Regards,
    Daniel Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, February 19, 2020 6:36 AM
  • Hi AlainRousseau6,
    Has your problem been solved? If it is resolved, we suggest that you mark it as the answer. So it can help other people who have the same problem find a solution quickly.
    Best Regards,
    Daniel Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Tuesday, March 3, 2020 8:31 AM