IBProvider — Code examples for Firebird and InterBase on C++, VBScript, Delphi, ASP, ADO.Net, C#, VB.Net

Examples for «LCPI ADO.NET Data Provider for OLE DB»
1. Using «LCPI ADO.NET Data Provider for OLE DB» with Firebird SQL Server
2. IBProvider and «Registration Free COM»
3. SSIS. Using «LCPI ADO.NET Data Provider for OLE DB» as a data recipient
4. Usage of System.IO.Stream (C#, FB)
5. Getting System.IO.Stream through OUT-parameter (C#)
6. Usage of System.IO.TextReader (C#)
7. Getting System.IO.TextReader through OUT-parameter (C#)
8. Execution of query «INSERT RETURNING» (C#)
9. Execution of query «INSERT RETURNING» [Compact version] (C#)
10. Execution of query «INSERT RETURNING INTO» (C#)
11. Execution of query «INSERT RETURNING INTO» [Compact version] (C#)
12. Write and read large (8GB) binary blob (C#)
13. Usage of OleDbDataReader.GetChars (C#)
14. Usage of OleDbDataReader.GetBytes (C#)
15. Creation and working with PACKAGE (C#, FB3)
16. OleDbDataAdapter and «INSERT RETURNING INTO» (C#)
17. Creation of provider through System.Data.Common.DbProviderFactories (C#)
18. Code Access Security and ADO.NET. Usage of OleDbPermission. (C#, NET4.x)
19. Work with native BOOLEAN datatype of Firebird and InterBase (C#, FB3, IB11)
20. Cancel of query execution (C#)
21. Cancel of query execution. Verification of implementation. (C#)
22. Parallel transactions within one connection. (C#)
23. Execution of the script with DDL queries and IN/OUT parameters. (C#)
24. Work with arrays in database table. (FB, C#)
25. Creation of database through ADO.NET provider. For Jedi only. (C#, Firebird 2.5+)
26. Collaboration of ADO.NET, ADODB and OLE DB technologies. (C#)
27. Work within ADODB connection. (C#)
28. Usage of connection pool from «LCPI OLE DB Services». (C#)
29. Getting information about OLE DB provider. (C#)
30. Reading of IsAutoIncrement attribute. (C#, FB3)
31. Getting statement plan. (C#, FB)
32. Using VBScript for database operations. (C#, VBScript, FB)
33. Work with IBProvider via LcpiComApiProvider (C#, FB)
34. Resetting the session settings before reusing a connection (C#, FB4)
 
Examples for .NET Core
1. Connection to database from .NET Core application. (C#, FB)
 
Examples for standard ADO.NET provider (System.Data.OleDb)
1. OLE DB Exceptions Handling (C#, VB.Net)
2. Database Connection methods (C#, VB.Net)
3. Work with Data Reader Object (C#, VB.Net)
4. Connection Pooling (C#, VB.Net)
5. ADO.Net Objects. Read and Write XML (C#, VB.Net)
6. Data Grid Filling (VB.Net)
7. Filter in Data Grid (VB.Net)
8. Stored procedure. Obtaining of row set (C#, FW 2.0)
9. DataGridView filling (C#, FW 2.0)
10. How to insert image into the blob field (C#, FW 2.0)
11. System.Data.OleDbDataAdapter and query «INSERT … RETURNING» (C#)
12. InterBase and Firebird Developer’s manual for Visual Studio Net. Part 1. Introduction to ADO.NET
13. InterBase and Firebird Developer’s manual for ADO.NET. Part 2. Using code generators and tools of Visual Studio 2008 (2005)
14. InterBase and Firebird in ADO Net. Part 3. Additional features: DDL, Metadata schemas, ODBC Escape Sequences
15. New features of Firebird 2.0. Examples for ADO.NET (c#)
16. Using new features of Firebird 2.1 in ADO.NET
 
ASP examples
1. Getting data from database (VB)
2. Getting picture from database (VB)
3. Working with Firebird and InterBase with limited system rights.
 
C++ and VB examples for Firebird and InterBase
1. Connection to DataBase (VB, C++)
2. Work with resulting set (VB, C++)
3. Work with command (VB, C++)
4. Work with BLOB field (VB, C++)
5. Arrays reading (VB)
6. Arrays writing (VB)
7. Update recordset (VB, C++)
8. Updatable recorset. Writing of changes in separate transaction (VB, C++)
9. Updatable recorset. Controlled mode (VB, C++)
10. Updatable recorset. Testing of query pool (VB)
11. Stored procedure. IN-OUT parameters (VB, C++)
12. Stored procedure. Obtaining of row set (VB)
13. Stored procedure. Use of property std_exec_sp (VB)
14. Stored procedure. ODBC call. IN-OUT parameters (WSF:VBS, C++)
15. Stored procedure. ODBC call. Obtaining of row set (WSF:VBS)
16. ActiveX Components. Manager of generators (VB)
17. ActiveX Components. Clone of connection in ADODB (VB)
18. ActiveX Components. Calculation of CPU time (VB)
19. Database metadata extract (VB)
20. Table metadata extract (VB)
21. Work with InterBase Exceptions (VB)
22. Work with InterBase using the ScriptControl (VB)
23. Usage of bookmarks (VB)
24. Work with InterBase triggers (VB)
25. MSSQL Linked Servers. Samples for article (WSF:VBS)
26. Work with transactions through SQL commands (VB)
 
Firebird and Delphi examples (author: Andrei Semak)
1. Work with parameters
2. Work with IN and OUT parameters in stored procedure
3. Work with BLOB fields and parameters
4. RecordSet getting
5. SELECT with parameter, Command and RecordSet
6. Working with Firebird and InterBase in Delphi. Part 1.