Topic outline

• Using XEP with .NET

  Using XEP with .NET

  Content Type
  Video

  Duration
  8m

  Level
  Introductory

  Learn how to use XEP with your .NET application to store and retrieve objects directly from InterSystems IRIS® data platform. This approach is optimally useful when you need to handle a high, real-time throughput of data.

  • Mark me "complete" for this video.

• Code Used in This Video

  Code Used in This Video

  Reference	Timestamp	Code
  Create a connection to InterSystems IRIS	3:20	EventPersister xepPersister = PersisterFactory.CreatePersister(); xepPersister.Connect(host, port, Namespace, username, password); Console.WriteLine("Connected to InterSystems IRIS.");
  Remove any existing data and create a table in InterSystems IRIS from a class	4:13	xepPersister.DeleteExtent(className); xepPersister.ImportSchema(className);
  Create an XEP Event object	4:34	Event xepEvent = xepPersister.GetEvent(className);
  Generate 100 C# objects from a class	4:52	CelestialReading[] readingsArray = CelestialReading.Generate(100);
  Store an array to the database	5:05	xepEvent.Store(readingsArray);
  Create and prepare a query	6:05	EventQuery<CelestialReading> xepQuery = xepEvent.CreateQuery<CelestialReading>(sqlQuery);
  Execute a query	6:09	xepQuery.Execute();
  Start looping through the result set	6:14	CelestialReading currentEvent = xepQuery.GetNext();
  Store updated object back to the database	6:18	xepQuery.UpdateCurrent(currentEvent);
  Alternative method to query the database using XEP	6:32	int processors = Environment.ProcessorCount; CelestialReading[]newArray = xepQuery.ExecuteAndFetchAll(processors);
  Close an XEP object	6:43	xepEvent.Close();
• What's Next?

  What's Next?

  • Read more about using XEP with .NET (documentation).
  • Connect your .NET applications to InterSystems® products and technologies with Connecting .NET Applications to InterSystems Products (learning path, 3h).